Example of Importing Primary Keys

In order to import a primary column, you must populate the following interface columns:

• These interface columns:

  • ROW_ID

  • IF_ROW_BATCH_NUM

  • IF_ROW_STAT

• The interface columns that map to the user key columns of the EIM table’s target base table

• The interface columns that map to the user key columns of the primary column’s base table

• The primary flag interface column that maps to the primary base column

• The interface columns that map to the primary’s intersection table

The intersection row must exist before setting the primary. If you want to import the intersection row and set it as the primary at the same time, you must also populate the interface columns that map to the intersection table’s required columns.

For example, If you want to update the S_ORG_EXT.PR_POSTN_ID primary column with the EIM_ACCOUNT interface table, you must populate the following:

• The interface columns:

  • ROW_ID

  • IF_ROW_BATCH_NUM

  • IF_ROW_STAT

• The interface columns that map to the user keys of the S_PARTY table (EIM_ACCOUNT’s target base table):

  • PARTY_UID

  • PARTY_TYPE_CD

• The interface columns that map to the user keys of the S_ORG_EXT table:

  • NAME

  • LOC

  • ACCNT_BU

• The primary flag interface column that maps to S_ORG_EXT.PR_POSTN_ID:

  • ACC_PR_POSTN

• The interface columns that map to the S_ACCNT_POSTN table (S_ORG_EXT.PR_POSTN_ID primary’s intersection table):

  • NAME

  • LOC

  • ACCNT_BU

  • POSTN_NAME

  • POSTN_DIVN

  • POSTN_LOC

  • POSTN_BU

  Note: You can find the S_ORG_EXT.PR_POSTN_ID primary’s intersection table using Siebel Tools. In Table, query and select S_ORG_EXT > Column, then query and select PR_POSTN_ID > Primary Inter Table Name property value.

The following are .IFB settings that you can use when running an EIM task that populates an EIM table to update a S_ORG_EXT row’s PR_POSTN_ID primary position to reference the S_POSTN row:

[Siebel Interface Manager]
USER NAME = "SADMIN"
PASSWORD = "********"
RUN PROCESS = Update S_ORG_EXT.PR_POSTN_ID
[Update S_ORG_EXT.PR_POSTN_ID]
TYPE = IMPORT
BATCH = 1
TABLE = EIM_ACCOUNT
ONLY BASE TABLES = S_PARTY, S_ORG_EXT, S_ACCNT_POSTN
INSERT ROWS = S_PARTY, FALSE
UPDATE ROWS = S_PARTY, FALSE
INSERT ROWS = S_ORG_EXT, FALSE
ONLY BASE COLUMNS = S_PARTY.PARTY_UID, \
S_PARTY.PARTY_TYPE_CD, \
S_ORG_EXT.NAME, \
S_ORG_EXT.LOC, \
S_ORG_EXT.BU_ID, \
S_ORG_EXT.PR_POSTN_ID, \
S_ACCNT_POSTN.OU_EXT_ID, \
S_ACCNT_POSTN.POSITION_ID

There are some cases that require you to include the MISC SQL parameter to set the primaries. For more information, see MISC SQL Parameter.