Siebel Enterprise Integration Manager Administration Guide > Siebel EIM Tables > EIM Table and Column Mappings >

Setting Explicit Primary Mappings


Primary foreign keys are columns that have names usually beginning with PR_ and are defined as primaries in the data model. If both the parent table and the primary child table of a primary foreign key are mapped to the same EIM table, then you should see an explicit primary mapping for this primary foreign key under the table mapping of the primary child table.

NOTE:  Before you can create an explicit primary mapping, both the parent and the primary child table must be mapped to the same EIM table.

If an explicit primary mapping exists, you can use EIM to set the primary explicitly during import or update by setting the primary flag column in the EIM table. For an example of this, see Example of Setting Explicit Primary Mappings.

Siebel Enterprise Integration Manager Administration Guide Copyright © 2006, Oracle. All rights reserved.