Specifying Remaining Records for Merge Processes
In a merge process, data from the record you select as the remaining record is preserved, while data from the other records is lost. Do not specify the same record as both the remaining record and the record to be deleted, or it will be deleted. You should also make sure that a record is specified as a remaining record only once in a batch.
Note: EIM behavior, whether executed from the GUI or through an EIM
run, does not merge data in the base record. It simply repoints the
foreign keys in the dependent child records. This applies to all columns
in the base table. This could lead to unintended data loss in an extension
column. For more information, see Example of Running a Merge with Custom Columns.