Table Counts Compare

This comparison type compares the total source and destination total count of column records.

Table Counts Compare Flow

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

  • Choose the Input Source Configuration and select the tables for table counts compare.

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

  • Choose the Input Source Configuration and select the tables for table counts compare.

  • Drag a Data Compare component and join the connections.

  • Select Table Counts Comparison 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 test case.

**Table Counts Compare Result **

  • Summary shows the percentage of matched and mismatched table counts.

  • _Details _shows Source and Target count of matched and mismatched tables count.

There is an option to the top right corner to** **share the link for this test case, and send it to other team members to examine the results.

Last updated