Merging Records 

Merging records is necessary when you have multiple records that contain the same information, but no single record that provides a complete and up-to-date version of that information.

Moreover, the challenge is not only to specify the correct value of each field, qualifier and attribute within a single record and then eliminate the duplicates, but also to detect all lookup field values and parent/child product relationships that reference any of the merged records and to reassign them to the single merged result record.

When you use the Merge Records command, MDM opens the Merge Records dialog. The dialog contains a grid as follows:

·        a column for the merged result record

·        a column for each selected record

·        a row for each of the fields, qualifiers and attributes of the selected records.

You can then merge the records and the underlying values as described in the following sections.

You can use the Merge Records command only to merge main table or object table records in Record mode. To merge hierarchy and taxonomy lookup table records, use drag-and-drop or the Cut and Paste as Merge commands in Hierarchy and Taxonomy modes (for more information, see Merging Nodes with Drag-and-Drop and Merging Categories with Drag-and-Drop).