EIM Explicit Primary Mapping Object Type

An EIM Explicit Primary Mapping specifies a column to be set as the Primary ID record for a multi-value link (MVL). For more information about MVLs and primaries, see About Multi-Value Links.

The EIM Explicit Primary Mapping object type contains these attributes:

• Name. This should be a concatenation of the destination table name and primary column name, separated by a period.
• Base Table Primary ID Column Name. Identifies the destination column to store the primary in.
• Inf Tbl Exp Primary Flg Col Name. Identifies the interface table column that indicates whether a particular record should be the primary.

Configure an EIM Table to Be Able to Set a Primary ID for a Multi-Value Link

To configure an EIM table to be able to set a Primary ID for a MVL, use these steps:

1. Validate that there's a primary field for the MVL defined on the business component. For example, Account has an MVL to Position and the primary is stored in the Primary Position ID field.
2. By inspecting the primary field, identify the underlying column where the primary is stored – in this example, S_ORG_EXT.PR_POSTN_ID.
3. On the EIM table, ensure that there's a column available to indicate which interface table reference will be the primary. If required, create a new column.
   • The column type should be Character(1), as it will have a value of Y or N.
   • The default should be N.
   • Do not create an Attribute Mapping for this column.
   • Note: For the Account Position example, the column already exists and is named ACC_PR_POSTN.
4. Create an EIM Explicit Primary Mapping as follows:

   Attribute	Description	Sample Value
   Name	Target table and column that you're setting	S_ORG_EXT.PR_POSTN_ID
   Base Table Primary ID Column Name	Name of column supporting the Primary ID field on the target business component	PR_POSTN_ID
   Inf Tbl Exp Primary Flg Col Name	Source column in the interface table that indicates whether a given record is the primary	ACC_PR_POSTN

   To use the EIM Explicit Primary Mapping to set a primary, you'll need to determine which record in your EIM batch represents the primary for each set of records with the same user keys.

   To continue the Account/Position example: If you were to have an account with three positions, you'd need to load your EIM interface table with three rows that would have identical account name and location. This ensures that only one account is created, but different position information exists on each record.

   To make one the primary, set the value to Y for the Inf Tbl Exp Primary Flg Col Name attribute above, such as ACC_PR_POSTN. After running the EIM job, that position will be marked as the primary for that account.

   Caution: Do not mark multiple records as the primary for the same logical target record, as results will be unpredictable.