The following conditions must be true for the sort operation to take effect:
The Hierarchy Processor transformation is connected directly to the Target transformation.
All sort fields are connected to the Target transformation.
The data types in the connected order by fields match the data types in the target fields.
Configure order by fields on the