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


UPDATE ROWS

  • This parameter specifies whether foreign references in the named table should be updated.
  • Valid values are TRUE or FALSE.
  • Default value is TRUE.
  • Example: UPDATE ROWS = S_CONTACT, FALSE
  • This above example restricts any update including the updating of foreign key references in the S_CONTACT table while performing the EIM Merge.
  • Care should be taken while setting FALSE value, because it might result in dangling foreign key references.

No comments:

Post a Comment