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.

image-20200513121635379