Data Migration Validation

This comparison option is used to compare the same type of schema.

Data Migration Validation Flow

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

  • Choose the Input Source Configuration and select the tables for Data Migration Validation.

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

  • Choose the Input Source Configuration and select the tables for Data Migration Validation.

  • Drag a Data Compare component and join the connections.

  • Select Data Migration Validation 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.

    • If the column type differs, the system will show a red icon with the following message to the user "Schema should be same for data migration compare" beside the table mapping.

    • Remove the column/table if different type of columns are mapped.

    • Data types should be the same for Data Migration validation.

  • Save and execute the flow.

We can compare the selected source and destination tables to view

  • Source and Destination Record Distribution.

  • Source and Destination Data Mismatches.

  • Success/failure results of each mapped column are shown in Test Case Report.

Last updated