Compare Job
A Compare Job validates and compares two data sources—one designated as the Source and the other as the Target. The job identifies differences between datasets based on a selected primary key or composite key.
Tests Performed During Comparison
Duplicates in Source – Identifies duplicate records in the source dataset based on the primary key.
Duplicates in Target – Identifies duplicate records in the target dataset based on the primary key.
Missing in Source – Detects records present in the target but absent in the source.
Missing in Target – Detects records present in the source but absent in the target.
Column-wise Comparison – Compares individual column values between source and target using the primary key.
Row-wise Comparison – Compares complete records between source and target using the primary key.
How to Create a Compare Job
Creating a Compare Job involves a guided configuration process where you define the data sources, keys, and validation rules to be applied during comparison.
Selecting the Source and Target data sources
Defining the primary or composite key for comparison
Reviewing and creating the job
For a detailed, step-by-step walkthrough on how to configure and create a Compare Job, refer to the guide below:
Last updated