Siebel Enterprise Integration Manager Administration Guide > Merging Data >

EIM Merge Process

During its multiple passes through the EIM tables, EIM completes the following tasks within a merge process:

• Initialize the EIM tables for merge.
• Select for merge the rows with matching user keys in the EIM tables.
• Merge child rows into the replacement rows. EIM then deletes rows from the target base table that are specified in the EIM table.
  • For deleted rows, EIM sets T_MERGED_ROW_ID to the row_id of the row that was merged into (the surviving row).
  • EIM sets t_deleted_row_id to the row_id of the deleted base table row.
• Update child rows containing foreign keys that point to newly deleted rows. For base tables that have foreign keys in newly deleted rows, EIM updates the foreign keys to point to surviving rows (depending on the value for update rows in the configuration file).

EIM provides comprehensive status information about each merge process. When the process ends, you should review this information. For more information, see Checking Merge Results.

Each task involves multiple passes; at least one pass is required for each EIM table included in the process.

NOTE:  Because the merge process affects the contents of base tables, transaction logging should be enabled during merge operations if you have active mobile Web clients, so that the appropriate transactions are captured for later synchronization. For more information, see Enabling Transaction Logging for Merge Processing.

Running through the EIM merge process requires that you perform the following steps, which are discussed in the remaining sections of this chapter:

1. Preparing the EIM Tables for Merge Processing.
2. Editing the Configuration File for Merge Processing.
3. Running a Merge Process.
4. Checking Merge Results.