Tuesday, July 24, 2012

Siebel Interface 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. EIM process operates upon these tables and does the specified operation. Every interface table has columns that get mapped to base tables, few mandatory columns and many temporary columns. The mandatory columns are mainly ROW_ID, IF_ROW_STAT and IF_ROW_BATCH_NUM.

The temporary columns are those that are used by EIM task to manipulate data values at run times. These temporary columns store the ROW IDs of records, status of the record, uniqueness of the records, whether the record already exists in the database. Some temporary columns store the ROW ID values of deleted, merged, exported rows.

Every interface table, while loading data into, has to satisfy certain prerequisites as stated below:
  • Mandatory columns needs to be populated.
  • All the required columns has to be populated.
  • Populate the IF_ROW_BATCH_NUM with appropriate batch number.
  • Set the IF_ROW_STAT column with meaningful values.

Every Siebel interface table has 4 types of temporary columns as defined below:
  • UNQ column.
  • EXS column.
  • RID column.
  • STA column.

No comments:

Post a Comment