Compare Job Report

Validating and comparing the provided two data sources. These are the validation checks performed during comparison:

• Duplicates identified in Source

• Duplicates identified in Target

• Missing records found in Source when compared to Target

• Missing records found in Target when compared to Source

• Column-wise comparison performed

• Row-wise comparison performed

---

Column-wise Comparison

Comparison performed for each column between Source and Target. Each field is compared individually to identify matching and mismatching values.

Sample Output

transactionid	accountbalance_Source	accountbalance_Target	accountbalance_Match	accountid_Source	accountid_Target	accountid_Match	currency_code_Source	currency_code_Target	currency_code_Match
TX000001	449874.48	449874.48	TRUE	AC00128	AC00128	TRUE	INR	INR	TRUE
TX000002	1210784.08	1210784.08	TRUE	AC00455	AC00455	TRUE	INR	INR	TRUE
TX000003	98766.8	98766.8	TRUE	AC00019	AC00019	TRUE	INR	INR	TRUE
TX000004	754077.28	754077.28	TRUE	AC00070	AC00070	TRUE	INR	INR	TRUE
TX000005	653787.2	653787.2	TRUE	AC00411	AC00411	TRUE	INR	INR	TRUE
TX000006	68787.84	68787.84	TRUE	AC00393	AC00393	TRUE	INR	INR	TRUE
TX000007	1171870.48	1171870.48	TRUE	AC00199	AC00199	TRUE	INR	INR	TRUE

---

Row-wise Comparison

Comparison performed for the entire row between Source and Target. The complete record is evaluated, and the result indicates whether the row fully matches or not.

Sample Output

Row-wise Comparison

Sample Output

transactionid	accountid	transactionamount	transactiondate	Source	Row_Match
TX000001	AC00128	1239.92	11-04-2023	Source	TRUE
TX000001	AC00128	1239.92	11-04-2023	Target	TRUE
TX000002	AC00455	33109.12	27-06-2023	Source	TRUE
TX000002	AC00455	33109.12	27-06-2023	Target	TRUE
TX000003	AC00019	11113.52	10-07-2023	Source	TRUE
TX000003	AC00019	11113.52	10-07-2023	Target	TRUE

---

Report Download

All comparison result files are available for download.

Compare-report