Attribute Selection Type Setting

Controls the method used to coalesce attribute values from the different records in a merge set onto the master record.

The underlying profile option is ZCH_SETATTRIBUTE_TYPE. The options are:

  • No attribute survivorship rules selected: Merge only replaces null values on the master with non-null values from the duplicates.

  • Use source confidence with oldest record as the tie breaker: In addition to replacing nulls with non-nulls, merge picks the attributes for the master based on the source confidence values configured using the Manage Source System Confidence setup task. In the case of multiple records in the duplicate set sharing the highest source confidence value for a given attribute, the value created at the earliest point in time is selected.

  • Use source confidence with newest record as the tie breaker: In addition to replacing nulls with non-nulls, merge picks the attributes for the master based on the source confidence values configured using the Manage Source System Confidence setup task. In the case of multiple records in the duplicate set sharing the highest source confidence value for a given attribute, the value created at the most recent point in time is selected.

  • Use Oracle business rules: In addition to replacing nulls with non-nulls, merge picks the attributes for the master based on logic configured with Oracle business rules using the Manage Survivorship Rules setup task.

Consider these points:

  • The source confidence-based survivorship methods use optimized internal processes and may offer the best performance.

  • The Attribute Selection Type can't be Oracle business rules if the Merge Scope is set to Customer data management specific areas with restrictions.