Thursday, August 16, 2012

An Overview to EIM Process

There are four types of process in EIM. They are :-
  • Import Process.
  • Export Process.
  • Delete Process.
  • Merge Process.

Import Process

  • Import Process is basically used to Insert or Update the data from external system into the Siebel base tables.
  • Identify and validate the data to be imported.
  • Identify the column mappings and user key columns of the data to be imported.
  • Import the data in the order of the business model.
  • Set the value of IF_ROW_STAT to FOR_IMPORT before load which will get changed to IMPORTED after process successfully commits.

Export Process

  • Export Process is basically meant for exporting the data from the base table into the EIM tables.
  • Exported data can be copied  into Other data bases.
  • Preserved Column Values - The values for the LAST_UPD and CREATED columns in the interface tables will always contain the values for the LAST_UPD and CREATED columns from the target  base table.
  • You can verify export results by checking IF_ROW_BATCH_NUM equals to the batch number for the export.
  • The value of IF_ROW_STAT will be EXPORTED after process commits successfully.

Delete Process

  • To delete any record from SIEBEL we will be using SIEBEL DELETE process.
  • EIM initializes the interface tables for deletion.
  • It applies filter logic to select rows for deleting. It select rows with matching user keys in the interface tables or deletes the records with the matching criteria as given in the IFB file.
  • EIM updates other tables with rows containing foreign keys that point to newly deleted rows.
  • Deletion process will delete/Update  the corresponding records from tables where the ROW_ID of record is referred as foreign Key.
  • EIM uses a combination of interface table row contents and configuration file parameter values to determine the method for selecting rows to be deleted. 
  • The following methods are supported
               1) DELETE EXACT
               2) DELETE MATCHES
               3) DELETE ALL

To know more on delete process, click here . . .

Merge Process

  • Merge process is basically meant for Merging the records.
  • During Merge Process we identify the Parent record and Child records to be merged.
  • All the references (ROW_ID) of Child records will be replaced by parent record and Child records will be deleted.
  • While Populating the EIM ,IF_ROW_MERGE_ID is used to distinguish between  parent and child records by EIM process.
  • For Parent Record  IF_ROW_MERGE_ID is kept NULL and for Child record, the ROW_ID (EIM tables) of parent is populated.
  • Can be used only to merge data from primary base table and not the secondary tables.
To know more on merge process, click here . . .

No comments:

Post a Comment