Apparatus, method, and computer program product for synchronizing data sources

摘要

A method is provided for synchronizing data sources. The method includes receiving at least first and second data tables. The data tables have one or more mutually similar fields and one or more dissimilar fields from one another. First normalized, second normalized, and intermediate data tables are stored, each including respective first normalized, second normalized, and intermediate data table fields that each correspond to the mutually similar fields of the first and second data tables. The first normalized data table is at least partially populated with corresponding entries from the first data table and the second normalized data table is at least partially populated with corresponding entries in the second data table. Intermediate data table entries are respectively replaced with corresponding inconsistent data entries of the first and second normalized data tables. An apparatus and a computer program product for accomplishing the above method are also provided.