The Matching Process
The matching process performs the following operations in the given sequence:
1. It retrieves records from the Consolidation table that are in the Cleansed state.
2. It determines if there is a matching record:
a. If a matching record does not exist, the process creates a record in the Gold table.
b. If a matching record exists, the matching process applies the survivorship rules and updates the existing Gold record with the relevant attributes from the record being consolidated.
3. Once matching is complete, it updates the record in the Consolidation table with the status corresponding to the action performed, either Create Auto, Create Manual, Linked Auto, or Linked Manual.
Before defining qualifiers for the Consolidation Gold object, you must define additional qualifiers for the Consolidation object at the object level.
OneData does not invoke the consolidation process if the Consolidation object is a sub-type created in Nova mode or if the Consolidation object is marked as both a Consolidation object and Consolidation Gold object.
The data quality process does not differentiate between match candidates that are active records and logically deleted but unpurged records. Consequently, during matching, the data quality process fetches the logically deleted record that is a match candidate and, if the deleted record has a better match score than the active record, tries to link the deleted record with the consolidation record. At this point, the data quality process reports validation errors.
The selection of logically deleted records for match candidates is done to eliminate duplicate records in the consolidation Gold table if, at some later point of time, a user restores the same deleted record.
To resolve the validation errors, restore the logically deleted record or purge it. If you restore the logically deleted record, OneData links it to the record in the consolidation Gold table. If you purge the logically deleted record, OneData creates a new Gold record and links it to the consolidation table.