Import Process Parameters in IFB

These are the parameters which are only applicable to EIM Import process and are written with in the Process section in an IFB file used for import process. They are :-

COMMIT OPERATIONS

• Optional parameter that specifies the commit frequency while logging the transactions.
• Value specifies the number of records processed before a commit is done.
• Applicable only if DOCKING: TRANSACTION LOGGING is set in System Preferences.
• Default value is 0, which means commit has to be made at the end of EIM process.
• Example: COMMIT OPERATIONS = 100

FILTER QUERY

• Optional parameter that lets the user to specify an SQL statement which filters the records that needs to be processed.
• This query runs before the import process starts.
• The IF_ROW_STAT column of those records that fails this query for the particular batch as specified in the process section will be set as “IMPORT_REJECTED”.
• Example: FILTER QUERY = (IF_ROW_STAT <> “IMPORTED”)

IGNORE BASE COLUMNS

• Optional parameter that specifies which base columns has to be ignored for the particular EIM process.
• This parameter improves the EIM performance.
• You should not ignore the user key columns or required columns.
• Example: IGNORE BASE COLUMNS = S_ORG_EXT.HOME_PH_NUM

ONLY BASE COLUMNS

• Optional parameter that specifies which base columns has to be considered for the particular EIM process.
• This parameter improves the EIM performance.
• You should include all the user key columns and required columns.
• Example: ONLY BASE COLUMNS = S_ORG_EXT.NAME, S_ORG_EXT.LOC

UPDATE ROWS

• Optional parameter that specifies whether to update the column values in the base table with that of in EIM table.
• Valid values are TRUE or FALSE.
• Default value is TRUE.
• Example: UPDATE ROWS = S_ORG_EXT, FALSE

ATTACHMENT DIRECTORY

• Optional parameter that specifies the directory path containing the attachments to be imported.
• This directory path should exist on one of the Siebel server machine.
• In case of remote machine, map the path to a drive and specify the drive name to this parameter.
• Default value is <SIEBEL_HOME>\INPUT
• Example: ATTACHMENT DIRECTORY = X: ,Where X: is mapped to \\CRMDEV02\siebsrvr\INPUT

DEFAULT COLUMN

• Optional parameter that lets you to specify a value for the EIM table column.
• This parameter applies only to Import process.
• This value will be only used if the EIM table column is null.
• Example: DEFAULT COLUMN = ACCNT_BU, “HP Americas”

FIXED COLUMN

• Optional parameter that lets you to specify a value for the EIM table column.
• This parameter applies only to Import process.
• This value will be used overriding the value in the EIM table column if any.
• Example: FIXED COLUMN = ACCNT_BU, “HP Americas”

INSERT ROWS

• Optional parameter that specifies whether to insert records into the particular base table or not.
• Valid values are TRUE or FALSE.
• Default value is TRUE.
• Example: INSERT ROWS = S_ORG_EXT, FALSE
• If the specified table is an EIM table, the value applies to all the base tables that were mapped to this EIM table.
• Example: INSERT ROWS = EIM_ACCOUNT, FALSE

MISC SQL

• This parameter is used to specify the type of primary need to be set while updating the primary child.
• Types of primaries are explicit primary and implicit primary.
• If set as explicit primary, EIM will consider the record where the primary child column in the EIM table is set.
• Example: MISC SQL = EXPR_S_POSTN_PR_EMP_ID
• If set as implicit primary, the first child record of the parent as specified in the EIM table will be considered as child record.
• Example: MISC SQL = IMPR_S_POSTN_PR_EMP_ID
• In cases, we might tell EIM to use explicit primary whenever specified and implicit primary if not. This can be set as shown below.
• MISC SQL = EXPR_S_POSTN_PR_EMP_ID, IMPR_S_POSTN_PR_EMP_ID

NET CHANGE

• Optional parameter that specifies how to handle the non user key null columns in the EIM table.
• Valid values are TRUE or FALSE.
• Default value is TRUE.
• If set to TRUE, the null values in the non user key null columns will be ignored.
• If set to FALSE, the null values in the non user key null columns will be applied to the base tables also.
• Example: NET CHANGE = FALSE
• This parameter applies only to Import process.

TRIM SPACES

• Optional parameter that specifies whether to remove the trailing spaces from the column values before importing.
• This parameter applies only to Import process.
• Valid values are TRUE or FALSE.
• Default value is TRUE.
• Example: TRIM SPACES = FALSE