Data Reconciliation using Informatica Cloud
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...