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
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
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.
Last updated