Data Steward Guide

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

Back Next

Consolidating the Unmerged Record with the Matched

Click this button (in the Cell data portion of the window) to consolidate (merge) the record selected in the Unmerged data list box with the record selected in the Matched data list box.

Consolidating two records has the following effects:

The row in the base object table that is displayed in the Matched Data pane disappears. The corresponding row in the

cross-reference

now points to the surviving row in the base object table. If the record that you consolidated into (the record in the Matched data list) was already a consolidated record, then the record will be removed from the queue entirely.

The surviving row in the base object table contains the most-trusted values from the cross-reference table. If the trust levels are equal, then the data from the unmerged row prevails. The row ID from the matched row remains in the base object.

The consolidated record can have a value that is a pointer to a value in another table. For example, suppose you have two base objects, a Customer and an Address. The Customer base object contains customer name information. The Address object contains address information, as well as a pointer to the Customer information, as these things must go together. If a Customer record and its associated Address are consolidated with another Customer/Address record, then a pointer from one of the Address records is lost in the consolidation. In this case, the pointer value is changed so that it points to the surviving row.

Values are never actually lost in the process of consolidating. Values that do not end up in the surviving record are always kept and managed by Informatica MDM Hub so that they are available should you choose to unmerge records.

If there are pointers to values in other tables that must be updated, the process of consolidating two records can result in many other records being affected.

Use this option if you want the records to be merged, but you don’t want to have to wait while they merge and any other impacted records are updated. This option will flag the match pair for automerge and will remove the match from your user assignment list. The next time the automerge procedure is run, the records you flagged for automerge will be merged.

This button does not display if you did a “Search for potential matches” in the Matched Data panel.

Use this option if you want to change the package that is used to display the data in this section.

Rename Saved Search

Table of Contents

Data Steward Guide

Data Steward Guide

Consolidating the Unmerged Record with the Matched

Consolidating the Unmerged Record with the Matched