When you add transformations between the sort origin and the Joiner transformation, use the following guidelines to maintain sorted data:
Do not place any of the following transformations between the sort origin and the Joiner transformation:
Custom
Unsorted Aggregator
Normalizer
Rank
Union transformation
XML Parser transformation
XML Generator transformation
Mapplet, if it contains one of the above transformations
You can place a sorted Aggregator transformation between the sort origin and the Joiner transformation if you use the following guidelines:
Configure the Aggregator transformation for sorted input.
Use the same ports for the group by columns in the Aggregator transformation as the ports at the sort origin.
The group by ports must be in the same order as the ports at the sort origin.
When you join the result set of a Joiner transformation with another pipeline, verify that the data output from the first Joiner transformation is sorted.
You can place the Joiner transformation directly after the sort origin to maintain sorted data.
ASK INFAPreview
