Data reconciliation allows to check the integrity of the loaded data. A successful data reconciliation process should only specify whether or not the data is correct. It will not indicate why the data is not correct. Whereas Data Reconciliation process answers “what” part of the question, not “why” part of the question.
PROLIM Data Reconciliation helps to identifies misalliances across any database management system and provides drill down reports on the same. The Reconciliation Framework comprises a set of reconciliation jobs that will allow tracing of records from the source systems to the target systems.
The objective of the reconciliation is to check if the records that were sent from the source systems were either received by the target systems or identified in the error logs.