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