Use a Sorter transformation to sort data in ascending or descending order, according to a specified sort condition. You can configure the Sorter transformation for case-sensitive sorting and for distinct output. The Sorter transformation is a passive transformation.
You can use the Sorter transformation to increase performance with other transformations. For example, you can sort data that passes through a Lookup or an Aggregator transformation configured to use sorted incoming fields.
When you create a Sorter transformation, specify fields as sort conditions and configure each sort field to sort in ascending or descending order. You can use a parameter for the sort condition and define the value of the parameter when you configure the mapping task.
Note: In advanced mode, make sure that the following conditions are true for the Sorter transformation to take effect:
•The Sorter transformation is connected directly to the Target transformation.
•All sort fields used in the sort condition are connected to the Target transformation.
•The data types in the connected sort fields match the data types in the target fields.