What are the different sorting options in the Aggregate Transformation and how do they impact the output?¶
There are three sorting options found in the Aggregate Transformation properties:
- Incoming data is presorted on group by fields: In this option, aggregate transformation requires the incoming data to be pre-arranged on the basis of “Group-by” field.
- Sort Incoming data before building aggregate: When this option is selected, the incoming data will be sorted before applying the aggregate functions.
- Build aggregate using unsorted data: This option builds aggregate using the incoming data which may or may not be sorted.