Data Profile Compare

This compare option compares the Data Profiles of the Source and Target tables.

Data Profile Compare Flow

• Drag a Source component from the palette to the canvas.

• Choose the Input Source Configuration and select the tables for data profile compare.

• Drag a _Target _component from the palette to the canvas.

• Choose the Input Source Configuration and select the tables for data profile compare.

• Drag a Data Compare component and join the connections.

• Select Data Profile Compare from the drop-down menu that appears at the bottom of the screen.

• In the Mapping tab, the tables with the same name are auto mapped. You can manually map the other tables and the corresponding columns.

• Save and execute the flow.

Data Profile Compare Tables Mapping

Data Profile Compare Result

• Select the table from the dropdown menu to get the detailed information of the table's data.

• The columns with the same name are shown under Common Columns.

• Click on the columns to view the detailed information of Source and _Target _together.

Data Profile Compare Result

Data Profile Compare Result