EIM Merge Process Overview

• This process merges multiple records into one surviving record.
• During Merge Process we identify the Parent record and Child records to be merged into that.
• Records loaded in the identified interface table are matched against the corresponding base tables based on the user primary keys.
• All the references (ROW_ID) of Child records will be replaced by parent record and Child records will be deleted.
• While Populating the EIM ,IF_ROW_MERGE_ID is used to distinguish between  parent and child records by EIM process.
• For the Merge process, the surviving record will have a null value in the IF_ROW_MERGE_ID column. The records that has to merged into the survivor record (i.e. to be deleted from the system) will have the ROW_ID of the survivor record (EIM tables) as the value in its IF_ROW_MERGE_ID column.
• Only records having a user primary key can be merged.
• All the child records and the intersection table records for the deleted records will now point its reference to the surviving record after the merge process.
• Only the target base table records can be merged.