Thursday, August 16, 2012

EIM Import Process Overview

  • The process drives the new record inserts and updates on existing records in the Siebel base table.
  • The interface table need to be correctly identified.
  • Load the business data into the identified interface tables. 
  • Create the configuration file.
  • Set the value of IF_ROW_STAT to FOR_IMPORT before load.
  • Make sure all the user key columns and the required columns for the targeted base tables are populated in the corresponding columns mapped in the interface tables.
  • Start the EIM job manually by logging into the application and navigating to Administration – Server or via the command line.
  • As the process starts the EIM component picks up the records in the EIM table and scans the base table to see if the combination of the user keys  populated on the EIM table record does not exist in the base table and inserts the new record into the base table.
  • If the component finds the user key combination in the base table then it checks if there are any differing values on the non user key columns, if present updates the base table record accordingly. 
  • If a record is inserted / updated to all the base tables successfully then the IF_ROW_STAT is set as IMPORTED and IF_ROW_STAT_NUM will have value as ‘0’
  • Based on how the insertion happens the IF_ROW_STAT and IF_ROW_STAT_NUM columns are set accordingly. 
  • By default INSERT and UPDATE is set to TRUE in the IMPORT process. 

Points to be noted for Updating Records

  • EIM table should be populated with proper User keys to Update Base table records.
  • User Key combination must be exactly the same as in the base table for the UPDATE to happen. Else the data will be get IMPORTED.
  • If the Business columns in EIM table is having a value  which is different from base table then and then only the base table value will be get Updated.
  • If  EIM table column is having NULL value it will not affect the Base Table column.
  • Insert and Update of Base table can be achieved by Specifying the proper Parameters  in  configuration file (IFB).

No comments:

Post a Comment