Siebel Enterprise Integration Manager Administration Guide > Importing Data > Editing the Configuration File for Import Processing >

Process Section Parameters Used for Imports


Parameters in the process section apply only to that specific process and override any corresponding value in the header section for the specific process. This section describes the parameters used in the process section that are specific to an import process. For generic parameters that can be used in all EIM processes, see Process Section Parameters Generic to All EIM Processes.

Table 9 lists the parameters specific to an import process that appear in the process section of the EIM configuration file. (For the parameters specific to an import process that can appear in both the process section and the header section of the EIM configuration file, see Table 10.)

Table 9.  Import Process Parameters for the EIM Configuration File - Process Section
Parameter
Description

COMMIT OPERATIONS

Docking Log row commit frequency; default is 0.

FILTER QUERY

SQL preprocess filter query fragment.

Example: FILTER QUERY=(ACCNT_NUM = "1500")

This parameter names a query that runs before the import process. The query prescreens certain rows in the import batch, using data values in the EIM tables. Rows that do not meet the filter criteria are eliminated.

The query expression should be a self-contained WHERE clause expression (without the WHERE keyword) and should use only unqualified column names from the EIM table or literal values (such as name is not null).

By default, the FILTER QUERY parameter is not used.

IGNORE BASE COLUMNS

Specifies base table columns to be ignored by the import process. Use commas to separate column names, which can be qualified with base table names. Required and user key columns cannot be ignored. Use this parameter to improve performance when updating all but a few columns. The default is to not ignore any base table columns.

IGNORE BASE TABLES

Specifies base tables to be ignored by the import process. Use commas to separate table names. Target tables for EIM tables cannot be ignored. The default is to not ignore any base tables. Use this parameter to improve performance when updating all but a few tables. This parameter affects all EIM tables used in the import process.

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.

Example: ONLY BASE COLUMNS = S_ORG_EXT.NAME, S_ORG_EXT.LOC, S_ORG_EXT.BU_ID

ONLY BASE TABLES

Specifies and restricts selected base tables for the import process. Use commas to separate table names. Target tables for EIM tables must be included. The default is to process all base tables into rows that can be imported from the EIM tables. Use this parameter to improve performance when updating only a few tables. This parameter affects all EIM tables used in the import process.

Example: ONLY BASE TABLES = S_CONTACT, S_ORG_EXT

UPDATE ROWS

Optional base table, TRUE/FALSE toggle; default is TRUE.

For more information on the UPDATE ROWS parameter, see INSERT ROWS and UPDATE ROWS Parameters.

NOTE:  The ONLY BASE TABLES, IGNORE BASE TABLES, ONLY BASE COLUMNS, and IGNORE BASE COLUMNS parameters can be used to improve EIM performance.

Siebel Enterprise Integration Manager Administration Guide