Row count comparison of multiple tables (Bulk Row Count Compare)

You are viewing documentation for Data Trust v7.6 (latest).
Looking for the previous version? View v2024.06 documentation →

Data Trust › Scenario Studio › Scenario Builder

Row Count Comparison of Multiple Tables

Perform row count validation across multiple table pairs in a single scenario run.

Overview

The Bulk Row Count Compare scenario validates that record counts match between multiple source and target table pairs in a single scenario run. It is the fastest way to verify volume consistency across an entire schema after a migration or load.

Note: Ensure all required connection profiles are configured in the Administration module before building this scenario.

Prerequisites

• You are logged in to Data Trust with a Pro-User or Admin Pro-User role.
• Source and target connection profiles have been configured.

Steps

Path: Data Trust › Scenario Studio › Scenario Builder › Row Count Comparison of Multiple Tables

Figure 1: TDR Header widget

This step involves interacting with the TDR Header widget within the Row Count Comparison of Multiple Tables workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 2: Source Connection

Select the appropriate connection from the dropdown to link this widget to its data source. Choosing the correct connection profile ensures the scenario reads from or writes to the intended database or file system.

Figure 3: Target Connection

Select the appropriate connection from the dropdown to link this widget to its data source. Choosing the correct connection profile ensures the scenario reads from or writes to the intended database or file system.

Figure 4: Source and Target Database Schema

This step involves interacting with the Source and Target Database Schema within the Row Count Comparison of Multiple Tables workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 5: Propose Mapping

The Reconciliation widget maps source fields to target fields for comparison. Use Smart Mapping to automatically propose column matches, then manually adjust any fields that were incorrectly paired before saving.

Figure 6: Configure Email

The Email widget sends an automated result notification to configured recipients after the scenario finishes executing. Provide the recipient addresses, subject, and choose whether to attach the exception report or include a summary in the email body.

Figure 7: Scenario Execution Summary

The Scenario Execution Summary page presents the full outcome of the scenario execution including record counts, match rates, and any detected exceptions. Drill into exception records to inspect individual mismatches and use the Export to CSV option to share results with stakeholders.