📊Comparing Jobs
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 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 target but absent in source.
Missing in Target – Detects records present in source but absent in target.
Column-wise Comparison – Compares individual columns between source and target using the primary key.
Row-wise Comparison – Compares complete records between source and target using the primary key.
Last updated