Showing posts with label Import Process. Show all posts
Showing posts with label Import Process. Show all posts

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.

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.

Wednesday, July 25, 2012

Import Process Parameters in IFB

These are the parameters which are only applicable to EIM Import process and are written with in the Process section in an IFB file used for import process. They are :-

COMMIT OPERATIONS

  • Optional parameter that specifies the commit frequency while logging the transactions.
  • Value specifies the number of records processed before a commit is done.
  • Applicable only if DOCKING: TRANSACTION LOGGING is set in System Preferences.
  • Default value is 0, which means commit has to be made at the end of EIM process.
  • Example: COMMIT OPERATIONS = 100