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 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.