What exactly is Data Reconciliation?

Question

I have experience in developing MS Access Databases as well as reporting however, when this term was thrown at me I was unsure of it meaning. Please help.

Answer 1

In a informations system, data is sometime replicated across multiple systems. This is done to ensure data availabilty to different systems without a performance impact.

Whenever, there is data redundancy, data reconciliation becomes necessary to ensure same data in all systems is consistent.

reconcile - compare data from one system with another and ensure it is similar or same

also, when information systems are changed, data residing in the system needs to be migrated to the new system. in this case also, the data needs to be reconciled once the migration is over to ensure that all data is copied into new system accurately and no data loss has happened.

mostly reconciliation is done via Reports

hope this helps!

Answer 2

Check out this page, it explains a lot:
http://www.dmreview.com/article_sub.cfm?articleId=1016588