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 and Cleansed (Reviewed) state.
2. It determines if there is a matching record in the Consolidation Gold object corresponding to the consolidation 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 links the consolidation record to the existing gold record. It also updates the existing Gold record with relevant attributes from the record being consolidated based on the survivorship rule.
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.
Important:webMethods 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.
Note:
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, webMethods OneData links it to the record in the consolidation Gold table. If you purge the logically deleted record, webMethods OneData creates a new Gold record and links it to the consolidation table.