Configuring a Consolidation Transformation
When you configure the Consolidation transformation, you choose strategy types, choose strategies or write expressions, select a grouping port, and configure advanced options.
1. Select the Consolidation view.
2. Choose a strategy type.
3. Configure the strategy.
- - For the simple strategy type, select a strategy for each port.
- - For the row-based strategy type, select a strategy.
- - For the advanced strategy type, create an expression that uses consolidation functions.
4. In the Group By field, select the port that contains the group identifier.
5. Enable sorting on the Advanced view if the input data is not sorted.
6. Configure the output to contain consolidated records or all records.