Siebel Enterprise Integration Manager Administration Guide > Merging Data > Editing the Configuration File for Merge Processing >

Parameters Used for Merges in Both the Header and Process Sections


Table 17 describes the parameters that can appear in either the header section or a process section, and are specific to a merge process. For generic parameters that can be used in all EIM processes, see Process Section Parameters Generic to All EIM Processes.

Table 17. Merge Process Parameters for the EIM Configuration File - Header and Process Sections
Parameter
Description

SET BASED LOGGING

Specifies whether set-based logging is enabled. The default value is TRUE.

NOTE:  EIM will ignore this parameter if Enable Transaction Logging is unchecked in the Remote System Preferences view of the Administration - Siebel Remote screen.

For more information on this parameter, see SET BASED LOGGING Parameter.

UPDATE ROWS

Specifies whether the foreign key (or keys) that reference the merged rows in the named table need to be adjusted. Valid values are TRUE (the default) and FALSE.

NOTE:  Use the UPDATE ROWS = Table_Name, FALSE setting carefully. Inappropriate use can result in dangling foreign key pointers.

SET BASED LOGGING Parameter

When set-based logging is enabled, a separate log entry is generated for all rows in each table affected by EIM. This allows greater performance improvement because EIM can perform the operations as set operations in SQL, without resorting to row-by-row processing to support the transaction log. Set-based transaction logging is most useful when a table is read-only to mobile Web clients. Set-based logging is always the default for merge. The SET BASED LOGGING parameter must be set to FALSE to allow transaction logging for merge.

Siebel Enterprise Integration Manager Administration Guide Copyright © 2006, Oracle. All rights reserved.