Siebel Enterprise Integration Manager Administration Guide > Common EIM Usage Examples > EIM Import Process Examples >

Example of Updating Columns When There Are Two Records with the Same User Keys in a Single Batch

EIM does not update columns in the following scenario: you have two records with same user keys in the same batch, but with different nonuser keys to be updated.

This cannot be done because there is no way for EIM—which runs set-based operations—to know which record updates which of the non-user keys in one batch. EIM chooses the row with MIN(ROW_ID) and marks the other rows as duplicates.

To perform this kind of update, for which you are updating a record more than twice, you must run two different batches.

 Siebel Enterprise Integration Manager Administration Guide 
 Published: 05 January 2004