Setting the Intersection Table Merge Rule Field

The Intersection Table Merge Rule field depends on the following value that you set in the Intersection Table Conflict Resolution field:

• Merge. The Intersection Table Merge Rule field determines the field values that survive when Siebel Remote merges two records to resolve an insert conflict on an intersection table.

• A value other than Merge. Siebel Remote ignores the Intersection Table Merge Rule field.

Caution: For important caution information about setting the Intersection Table Merge Rule field, see Requirements for Extracting the Server Database.

For more information about resolving insert conflicts, see Setting the Intersection Table Conflict Resolution Field.

To set the Intersection Table Merge Rule field

1. Set the Intersection Table Conflict Resolution field to Merge.

2. Set the Intersection Table Merge Rule field to one of the following values:

   • First In. (Default value) Siebel Remote applies the following rules to fields in parent records, child records, and associated extension records:

     • Siebel Remote replaces existing NULL values with new, non-NULL values

     • Siebel Remote preserves existing, non-NULL values

   • Last In. Siebel Remote applies the following rules to fields in parent records, child records, and associated extension records:

     • Siebel Remote replaces existing NULL values and non-NULL values with new, non-NULL values.

     • If the corresponding new value is NULL, then Siebel Remote preserves existing, non-NULL values.