Wednesday, July 25, 2012

Merge Process Parameters in IFB

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


SET BASED LOGGING

  • This parameter specifies whether to enable the set based logging.
  • When enabled, a separate log entry will be generated for all the rows in each table that were processed by EIM. This allows greater performance.
  • When disabled, each and every row processed by EIM will have an entry in the transaction table.
  • Valid values are TRUE or FALSE.
  • Default value is TRUE.
  • Example: SET BASED LOGGING = TRUE

Delete Process Parameters in IFB

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

CASCADE DELETE ONLY

  • Optional parameter that tells whether to delete the child records when a parent record is deleted.
  • Valid values are TRUE or FALSE.
  • Default value is FALSE.
  • If set to FALSE, EIM deletes the parent record and sets the foreign key column in the child records to NULL.
  • Example: CASCADE DELETE ONLY = TRUE

Export Process Parameters in IFB

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

ATTACHMENT DIRECTORY

  • Optional parameter that specifies the directory path to where the attachments have to be exported.
  • This directory path should exist on one of the Siebel server machine.
  • In case of remote machine, map the path to a drive and specify the drive name to this parameter.
  • Default value is <SIEBEL_HOME>\OUTPUT
  • Example: ATTACHMENT DIRECTORY = X:, Where X: is mapped to \\CRMDEV02\siebsrvr\OUTPUT

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

General Process Parameters in IFB

These are the parameters which are common to all the EIM process (Import,Export,Delete,Merge) and are written with in the Process section in an IFB file. They are :-

BATCH

  • Required field that specifies the batch number, which is used to identify the set of records that should be considered for this EIM process.
  • This batch number corresponds to the number specified in the IF_ROW_BATCH_NUM column of the EIM table.
  • Valid values are 0 to 2147483647 (231 – 1).
  • Batch numbers can be specified in ranges or as a comma delimited format.
  • Example: BATCH = 100 – 110, BATCH = 100, 103, 120.
  • If batch number is specified wrongly in IFB file, the EIM throws an error stating, no records found for the stated batch number.

General Header Parameters in IFB

These are the global parameters which are used in an IFB file and are written with in the Header section in an IFB file. They are :-

CONNECT

  • Specifies the ODBC source name of the database to be used


LOG TRANSACTIONS TO FILE

  • This parameter specifies whether the transactions to be logged to a file or docking transaction table.
  • Valid values are TRUE or FALSE.
  • If set to TRUE, the transaction details are logged into the directory <SIEBEL_FILE_SYSTEM>EIM.
  • If set to FALSE, the transaction details are logged into the S_DOCK_TXN_LOG table.
  • This parameter doesn’t make sense, if DOCKING: TRANSACTION LOGGING parameter in System Preferences is set to FALSE.