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

General Process Parameters in IFB

These are the parameters which are common to all the EIM process (Import,Export,Delete,Merge) and are written with in the Process section in an IFB file. They are :-

BATCH

• Required field that specifies the batch number, which is used to identify the set of records that should be considered for this EIM process.
• This batch number corresponds to the number specified in the IF_ROW_BATCH_NUM column of the EIM table.
• Valid values are 0 to 2147483647 (2³¹ – 1).
• Batch numbers can be specified in ranges or as a comma delimited format.
• Example: BATCH = 100 – 110, BATCH = 100, 103, 120.
• If batch number is specified wrongly in IFB file, the EIM throws an error stating, no records found for the stated batch number.

General Header Parameters in IFB

These are the global parameters which are used in an IFB file and are written with in the Header section in an IFB file. They are :-

CONNECT

• Specifies the ODBC source name of the database to be used

LOG TRANSACTIONS TO FILE

• This parameter specifies whether the transactions to be logged to a file or docking transaction table.
• Valid values are TRUE or FALSE.
• If set to TRUE, the transaction details are logged into the directory <SIEBEL_FILE_SYSTEM>EIM.
• If set to FALSE, the transaction details are logged into the S_DOCK_TXN_LOG table.
• This parameter doesn’t make sense, if DOCKING: TRANSACTION LOGGING parameter in System Preferences is set to FALSE.

IFB Parameters for EIM

The parameters used in an IFB are classified as follows:

• General Header Parameters.
• General Process Parameters.
• Import Process Parameters.
• Export Process Parameters.
• Delete Process Parameters.
• Merge Process Parameters.

General Header Parameters

These are the global parameters which are used in an IFB file and are written with in the Header section in an IFB file. They are :-

• CONNECT
• LOG TRANSACTIONS TO FILE
• PASSWORD
• PROCESS
• [Siebel Interface Manager]
• TABLEOWNER
• USER NAME

To know more on general header parameters, click here . . .

EIM Configuration File (IFB File)

An EIM process reads a configuration file, where different kinds of parameters are set for an EIM process. The configuration file, in short IFB file, defines the type of process, EIM table involved, batch number, and lots of other parameters.

An IFB file has two sections :-

1. Header Section.
2. Process Section.

Header Section

The header section defines the parameters that are common to all the processes defined in the file. 

Process Section

The process section defines parameters which are specific to that particular section.

Temporary Columns in EIM Tables

EIM tables (Interface tables) act as staging area which holds the data that has to be imported, data exported from the Siebel base tables, data to be deleted and that to be merged.

Every Siebel interface table has 4 types of temporary columns as defined below:

• UNQ column.
• EXS column.
• RID column.
• STA column.

Each of the temporary columns has a naming format as follows: 

" T_<base table without prefix S_>__<temporary column type> "

       Examples: T_ORG_EXT__UNQ, T_ORG_EXT__EXS, T_ORG_EXT__STA, T_ORG_EXT__RID

There are few exceptions for this naming rule.

       Examples: T_ACCNTPOST__STA, T_OPTYPOSTN__RID, T_PRODLNPOSTN__RID