You can create expressions that contain simple consolidation functions or row-based consolidation functions. You use the simple consolidation functions to build a consolidated record based on port values in the record group. You use the row-based consolidation functions to select a row from the record group.

Consolidation expressions must populate all of the output ports in the Consolidation transformation. If consolidation expressions do not use all output ports, the transformation causes mappings to fail.

You can use a simple or row-based strategy as a template for an advanced strategy. Configure a simple or row-based strategy and then select Advanced. The Consolidation transformation generates an expression with functions that perform the strategy. You can add more functions to implement additional requirements.