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:
- 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.
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:
- The interface columns that map to the user keys of the S_PARTY table (EIM_ACCOUNT's target base table):
- The interface columns that map to the user keys of the S_ORG_EXT table:
- The primary flag interface column that maps to S_ORG_EXT.PR_POSTN_ID:
- The interface columns that map to the S_ACCNT_POSTN table (S_ORG_EXT.PR_POSTN_ID primary's intersection table):
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:
PASSWORD = "<SADMIN's password>"
RUN PROCESS = Update S_ORG_EXT.PR_POSTN_ID
[Update S_ORG_EXT.PR_POSTN_ID]
ONLY BASE TABLES = S_PARTY, S_ORG_EXT, S_ACCNT_POSTN
INSERT ROWS = S_ORG_EXT, FALSE
ONLY BASE COLUMNS = S_PARTY.PARTY_UID, \
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 |
Siebel Enterprise Integration Manager Administration Guide Published: 05 January 2004 |