To define a consolidation process, configure the options on the
Consolidation
tab.
Select the
Consolidation
tab on the asset.
Select a consolidation mode. The mode defines the method that the Deduplicate transformation uses to consolidate sets of duplicate records into single, preferred records.
You can select one of the following modes:
No consolidation. The transformation does not create preferred records from the sets of matching records that the duplicate analysis defines.
Row-based consolidation. The transformation selects a preferred record from each set of matching records based on a strategy that you select.
Field-based consolidation. The transformation creates a preferred record based on a strategy that you specify for each field in the records. Field-based consolidation can combine values from more than one record to create a preferred record that is not present in the source data.
Configure the row-based or field-based strategies for the fields in the input records.
If you selected the field-based consolidation mode, optionally add one or more fields to the consolidation model.
The following field names are reserved on the deduplicate asset: