Preparing the EIM Tables for Import Processing

This section explains how to prepare the EIM tables for a subsequent import into a Siebel database. To import data, EIM reads data in the EIM tables and writes data in the appropriate Siebel base tables by making multiple passes through the EIM tables to:

• Set initial values for some columns in the EIM tables

  • When importing new data, make sure to populate the columns marked Required in the EIM table.

  • When updating existing records you do not need to populate the Required columns, but the user key columns must be populated.

    To find which columns are required, and which columns are user keys, generate a table mapping report. See Generating EIM Table Mapping Reports.

• Apply filter logic to select rows for importing

• Generate foreign key references and internal values

• Add or update relevant Siebel database rows

• Update each EIM table row to indicate its import status

For general information on EIM tables, see Siebel EIM Tables.