Posts

Showing posts from August, 2022

Data Reconciliation using Informatica Cloud

Image
Data Reconciliation using Informatica Cloud Data Reconciliation is the process of verify of the target data against the original source data. Why Data Reconciliation is needed:- During data migration, data might be lost during extraction from the source due to infrastructure or network issue  Data might be poorly formatted during the transformation Data might be duplicated during the source to the target load  Some data might be rejected while loading into the target  Some organizations rely on record counts and compare source and destination counts. This is better than doing nothing, but it does not solve the problem completely. If updates are not adequately captured or applied, the record counts may be the same but the data can be drastically different. For overcoming the above scenarios we need to verify the value in each field that is needed for analysis.  It will be time consuming to compare all the target fields with source fields when the target has hundreds o...