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