The Consolidation transformation generates consolidated records by applying strategies to groups of related records. The transformation contains an output port that indicates which record is the consolidated record. You can choose to limit the transformation output to include only consolidated records.

For example, you can consolidate groups of duplicate employee records that the Match transformation generates. The Consolidation transformation can create a consolidated record that contains merged data from all records in the group.

You can configure the Consolidation transformation to use different types of strategies based on your consolidation requirements. Use simple strategies to create a consolidated record from multiple records. When you use simple strategies, you specify a strategy for each port. Use a row-based strategy to analyze rows in the record group and create a consolidated record with the values from one of the rows. Use an advanced strategy to create a consolidated record by applying an expression that you create.