Services Integration Framework Guide

10.4 HotFix 3
- 10.5
- 10.4 HotFix 2
- 10.4 HotFix 1
- 10.4
- 10.3 HotFix 3
- 10.3 HotFix 2
- 10.3 HotFix 1
- 10.3

Back Next

Merge

Merge merges two base object records, creating a single, consolidated base object record by merging all the XREF records from the two base objects.

When two records are merged, one is designated the source record, one is designated the target record. The request merges the source record into the target record. This means that after the merge the ROWID for the combined record is that of the target record. All foreign keys pointing to the source record now point to the target record.

For example, there may be one base object record with the name “Alex Watson” and another with the name “Alexander Watson”; each base object record has its own set of cross reference records. These records are determined to represent the same person so the records are merged. The result is a single base object record that has all the cross reference records from the original two base object records. The consolidated value for each field in the record is determined by the trust configuration.

When you merge two records, Informatica MDM Hub does not check the match status of the records, it just merges the records as you specify. Using this class, it is possible to merge two completely dissimilar records, resulting in a nonsense record. For more information about merging, see the

Multidomain MDM Configuration Guide

An alternate to Merge is Multimerge, which can be used to merge two or more records in a single operation.

For more information, refer to the Merge Settings Tab on the Match/Merge Setup Details dialog in the MDM Hub Schema Manager, the

Multidomain MDM Configuration Guide

, and the

Multidomain MDM Data Steward Guide

State Management

When you merge records in a base object with state management enabled, you can merge records in any state. The target ROWID survives in the base object regardless of the hub state. Survivorship of values are based on the trust scores and the last updated date of the source record.

For more information on state management, see the

Multidomain MDM Configuration Guide

, and the

Multidomain MDM Data Steward Guide

Use Case

The following scenario uses the merge request:

Merge used with GetMatchedRecords
. You can use GetMatchedRecords to get a list of match candidates for a specified record. You can then display that list in a UI. If the user selects one of the candidate records, you can use merge to merge the two records.