Performance Tuning Guide > Tuning Siebel EIM for Performance >
Data Management Guidelines for Optimizing EIM
The following recommendations apply when performing the EIM loading process:
- The 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.
- 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 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.