Integrated matching groups together similar records and creates a "golden" record which is a consolidated version of all records in the group.
Integrated matching in Talend MDM enables you to deduplicate or reconciliate data by doing the following:
- Identify similar records and select the values to survive. This is known as the match and survivorship process.
- Build golden records.
- Create the merging tasks for records that need human intervention to be merged, and list them automatically in Talend Data Stewardship.
- Handle the merging tasks in Talend Data Stewardship, for example, change the survived values or remove extra records.
- Run the validation process again in the staging area.
Integrated matching only deals with records within the staging area, which is actually a mirror of the SQL storage used to store master data records.
Once the staging area has data records waiting for validation, MDM users can run the validation process to transfer data from the "staging area" to the "master database".
The integrated matching in MDM is different from the data matching with Jobs in that the native feature is fully integrated and all the logic is owned by MDM rather than in various Jobs.