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

Table Counts Compare Tables Mapping

**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.

Table Counts Result

Table Counts Matched/Mismatched Results

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.

Share Results