Siebel Enterprise Integration Manager Administration Guide > EIM: Examples of Common Usage > Other Examples >

Example of Using the NUM_IFTABLE_LOAD_CUTOFF Parameter

When the NUM_IFTABLE_LOAD_CUTOFF parameter is enabled, EIM loads all schema mappings if the value is less than the number of EIM tables used in the run process. To enable this parameter, set the value to a positive number that is less than the number of EIM tables used in the run process. For example, if the EIM process is using one EIM table, then the setting should be NUM_IFTABLE_LOAD_CUTOFF = 0.

When this parameter is disabled, EIM loads only mappings for the EIM tables used in the run process. This speeds up the dictionary loading process in EIM. To disable this parameter, set the value to -1.

NOTE:  NUM_IFTABLE_LOAD_CUTOFF is disabled by default.

EIM does not necessarily look at all of the EIM tables in the IFB file. EIM counts only the number of EIM tables being used in the running process.

For example, in the .IFB file that follows, there are three EIM tables: EIM_ACCOUNT, EIM_CONTACT, and EIM_OPTY. But there are only two EIM tables (EIM_ACCOUNT, EIM_CONTACT) for the process to be run (Import Objects). So with a NUM_IFTABLE_LOAD_CUTOFF value of 2, EIM does not load all of the schema mappings. If you want EIM to load all of the schema mappings in this example, set the NUM_IFTABLE_LOAD_CUTOFF value to 1 (or 0).

By setting the parameter to 2 in this example, you are disabling it because the number is equal to, not less than, the number of EIM tables used in the run process.

Sample .IFB file:

[Siebel Interface Manager]

PROCESS = Import Objects

[Import Objects]

TYPE = SHELL

INCLUDE = Import Accounts

INCLUDE = Import Contacts

[Import Accounts]

TYPE = IMPORT

BATCH = 100

TABLE = EIM_ACCOUNT

[Import Contacts]

TYPE = IMPORT

BATCH = 100

TABLE = EIM_CONTACT

[Export Opty]

TYPE = Export

BATCH = 100

TABLE = EIM_OPTY