Bookshelf Home | Contents | Index | Search | PDF

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

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 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 = "<SADMIN's 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.

Bookshelf Home | Contents | Index | Search | PDF