Siebel Enterprise Integration Manager Administration Guide > Merging Data >

Checking Merge Results

When a merge process ends, you should carefully check the results to verify that data was successfully merged. During each process, EIM writes comprehensive status and diagnostic information to several destinations.

During a merge process, EIM writes the following values to two special columns in the EIM tables:

To view the results of a merge

  1. Query the appropriate EIM table for rows whose if_row_batch_num equals the batch number for the merge process.
  2. Inspect the values of t_deleted_row_id and t_merged_row_id.

If error flags, SQL trace flags, or trace flags were activated for the EIM process, you can also use the trace file to view the results of the EIM process. For more information on viewing the trace file, see Viewing the Task Info Log.

 Siebel Enterprise Integration Manager Administration Guide 
 Published: 05 January 2004