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