This step builds aggregates in a group by fashion and does not require a sorted input since it processes all rows within memory. When the number of rows is too large to fit into memory, you need to use the combination of the Sort rows and Group by steps.
The name of this step as it appears in the transformation workspace.
Always give back a result row
If you enable this option, the Group By step will always give back a result row, even if there is no input row.
This can be useful if you want to count the number of rows. Without this option you would never get a count of zero (0).
The field that make up the group
After retrieving fields using the Get Fields button, designate the fields to include in the group. See the Group be step for more details.
After retrieving fields using the Get lookup fields button, designate the fields to include in the group. See the Group be step for more details.
All fields of this step support metadata injection. You can use this step with ETL Metadata Injection to pass metadata to your transformation at runtime.