Siebel Performance Tuning Guide > Tuning Siebel EIM >

Data Management Guidelines for Optimizing Siebel EIM

The following recommendations apply when performing the Siebel EIM loading process:

  • The Siebel EIM mapping chart shows that many of the EIM table columns derive their values not from legacy database fields but from unvarying literal strings. Avoid filling up the EIM tables with this type of information, because it slows down the movement of real legacy data from the EIM tables to the base tables.
  • Siebel EIM offers an alternative method for populating base table columns with unvarying literal strings, namely by using the DEFAULT COLUMN statement. This approach allows you to specify default literals that must be imported into the base tables without having to retrieve them from the EIM tables.

    For example, the Siebel EIM mapping chart shows Default Organization as the constant value for CON_BU in EIM_CONTACT, which in turn will move into BU_ID in S_CONTACT.

    The same result can be achieved with the setting DEFAULT COLUMN = CON_BU, Default Value in the .IFB file. There are many other opportunities for moving literal strings from the EIM tables to the .IFB file.

Siebel Performance Tuning Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.