TYPE: This parameter specifies the type of process being defined (IMPORT, EXPORT, DELETE, MERGE, or SHELL). A shell process uses the INCLUDE statement to invoke a sequence of processes in a single run.
BATCH: Specifies a required batch number for this process. This number is predefined as the user sets this number at the time of EIM table load. It is used to identify the set of rows to load from the interface tables for this specific process. It corresponds to the value in the interface table column IF_ROW_BATCH_NUM and must be a positive integer between 0 and 999999999999999 (up to 15 digits, no commas). To specify multiple batches, use a range or list of batch numbers.
BATCH=100-120
To list batches, use the comma-delimited format as shown in this example:
BATCH=100,103,104
It is recommended to use batch ranges (BATCH = x–y). This allows the user to run with smaller batch sizes and avoid the startup overhead on each batch. The maximum number of batches that one can run in an EIM process is 1,000.
TABLE: Specifies the name of an EIM table used in this process. From performance aspect the selection of EIM table is vital. The things that should be kept in mind while selecting the EIM table are discussed earlier.
TYPE = IMPORT
BATCH = 10000-10100
TABLE = EIM_ACCOUNT
ONLY BASE TABLE: Specifies and restricts selected base tables for the import process. Use commas to separate table names. Target table for interface tables must be included. This parameter is used to improve performance when loading some specific base tables. For example:
ONLY BASE TABLES = S_PARTY,S_ORG_EXT,S_ACCNT_POSTN,S_ORG_BU
IGNORE BASE TABLES: Specifies base tables to be ignored by the import process. Use commas to separate table names. Target tables for interface tables cannot be ignored. The default is to not ignore any base tables. Use this parameter to improve performance when loading all but a few tables.
ONLY BASE COLUMNS: Specifies and restricts base table columns for the import process. Use commas to separate column names, which can be qualified with base table names. Include all user key columns and required columns. Use this parameter to improve performance when updating many rows but few columns. The default is to process all interface columns mapped to the base table.
ONLY BASE COLUMNS= S_ORG_EXT.NAME, S_ORG_EXT.LOC, S_ORG_EXT.BU_ID
IGNORE BASE COLUMNS: Specifies base table columns to be ignored by the import process. This is also written with the same manner as ONLY BASE COLUMN. Required columns and user key columns cannot be ignored. Use this parameter to improve performance when loading all but a few columns. The default is to not ignore any interface columns.
IGNORE BASE COLUMNS = S_PROD_INT_BU.PR_FULFL_INVLOC_ID,S_PROD_INT_BU.PR_PROD_LN_ID
DEFAULT COLUMN: Specifies a default value for an interface table column. The syntax is COLUMN NAME, VALUE, as in the following example:
DEFAULT COLUMN = CURCY_CD, "USD"
The given value will be used only if the column is NULL in the interface table.
FIXED COLUMN: Specifies the value for a column from the interface table. The syntax is the same as for DEFAULT COLUMN. The given value will be loaded into the Siebel base table, overriding the value in the interface table column.
FIXED COLUMN = PARTY_TYPE_CD, "Organization"
INSERT ROWS: Specifying INSERT ROWS as FALSE indicates that rows from EIM table are not to be inserted into the specified Siebel base table. The default is INSERT ROWS = TRUE. To change this for all tables, use this syntax:
INSERT ROWS = FALSE
For a Siebel base table, the setting is applied when data is imported from any interface table as in the following example:
INSERT ROWS = S_ORG_BU, FALSE
INSERT ROWS = S_ACCNT_POSTN, FALSE
If the named table is an interface table, as in the example below, the setting applies to all Siebel base tables imported from this interface table.
INSERT ROWS = EIM_ACCOUNT, FALSE
UPDATE ROWS: This parameter specifies if foreign key references can be updated. The default value is UPDATE ROWS = TRUE which affects all tables. To change only for specific table(s), specify the table name as follows:
UPDATE ROWS = S_CONTACT, FALSE
If it is required to set the parameter as FALSE for most tables, and TRUE for only a few, use this method:
UPDATE ROWS = FALSE
UPDATE ROWS = S_CONTACT, TRUE
UPDATE ROWS = S_ADD_ORG, TRUE
By default, when importing information, EIM performs both inserts and updates based on the content of the batch set.
If the named table is an interface table, as in the example below, the setting applies to all Siebel base tables imported from this interface table.
UPDATE ROWS = EIM_ACCOUNT, FALSE
By default, INSERT ROWS and UPDATE ROWS are TRUE
Note: If neither INSERT ROWS nor UPDATE ROWS are set to FALSE, EIM has to perform additional processing (via SQL statements) to determine whether to update or insert. Basically when importing data via EIM, EIM will first look up user key columns in a base table. If it finds the matching user keys, EIM will continue to compare all non-user key columns in order to determine whether it needs to update the record or reject it as duplicate.1
MISC SQL: This parameter is used to set specific explicit or implicit primaries. “Explicit” is when it is required to set specific values as primaries. “Implicit” is when any of a group of values is acceptable. For example, you are importing one account with nine addresses. If any of the addresses is acceptable as being the primary, then set primary to implicit. EIM then selects one of the addresses as primary. If a specific address should be the primary, then set primary to explicit and indicate the primary account by setting its flag column.
For example, set EIM_ACCOUNT.ACC_PR_ADDR to “Y” for explicit Primary. For example,
MISC SQL = EXPR_S_ORG_EXT_PR_ADDR_ID
MISC SQL is intended for initial data loading only (with DOCKING TRANSACTIONS = FALSE).
Sometimes the intention is to apply explicit primary when specified and implicit primary otherwise. In that case, we mention the following in the ifb file:
MISC SQL = EXPR_S_ORG_EXT_PR_ADDR_ID, IMPR_ S_ORG_EXT_PR_ADDR_ID
USE INDEX HINTS: The default value for this parameter is TRUE. If it is set to TRUE, EIM generates hints during processing which helps in achieving performance gain. It is recommended for EIM processes to be tested with both TRUE and FALSE settings in order to determine which provides the better performance for each of the respective EIM job.