Siebel EIM

EIM Tuning - Reference

What is EIM

EIM is a data loading tool that reads data from EIM tables (staging table) and Inserts/Updates/Deletes data in/from Siebel base tables.
 

Why EIM tuning is important

  • Data conversion process is often underestimated and becomes bottleneck reaching go-live date.
  • The slow initial data conversion could result into large amount of delta updates to catch-up.
  • The incremental data loads – if not tuned and tested pro

EIM Data Loading : Oracle function - Bulk Collect

When loading data through EIM process, we normally use Pl/SQL procedures to fetch and process huge volume of records and  then load the data to EIM Interface tables. There are scenarios when the normal way of data loading into EIM tables take long time due to the bulk volume of records. Typical usage of SQL queries result in performance bottleneck issues due to the frequent context switches between the SQL and Pl/SQL engine

Implementation :

EIM Tuning to improve performance

Through EIM process we load bulk amount of data from an external system to Siebel base tables. The performance of these EIM jobs has to be maintained at optimum levels in order to reduce the load on the Siebel application and database servers. The following tips will help you in improving the EIM performance. Do a round of validation in development environment before running the EIM jobs on Production systems 

EIM Data Cleansing : Oracle function – Regular Expression

When loading data into Siebel through EIM, we do perform Data cleansing/massaging as per our 
 
business requirement. The cleansed data from Source is then loaded into the target EIM 
 
Interface tables
  Scenario:
Convert multiple spaces in address related columns to a single space for all records 
 
dynamically.

EIM Column Extension in Siebel 8.x

When extending a custom column in Siebel 8.X which have case and accent insensitive (CIAI) enabled, running EIM mapping wizard creates corresponding mapping in EIM  table. After which running an EIM job will cause the job to fail with the following error

 "SBL-EIM-00205: NULL target table for relation!" followed by "Failed to load the application dictionary"

Root Cause :

Recent content