Clever Geek Handbook

Informatica 9.1: If you pass a sorted input to an aggregator, does it give a sorted result or is it random?

In Informatica 9.1 unallocated collation I am using a sorted aggregator and there is a joiner after that; can i make my joiner a sorted joiner?
The question here is, if you pass a sorted input to an aggregator, what are the chances of getting a sorted result from it?

+3


source to share


2 answers


Such scenarios are discussed in the Advanced Transformation Guide. Notice the point in bold.



When you add transformations between the sort source and the transform joiner, use the following guidelines for maintaining sorted data:

  • Do not place one of the following conversions between the origin sort and the Joiner conversion:

    • Custom

    • Unsorted Aggregator

    • Normalizer

    • Level

    • Connection conversion

    • Converting XML Parsers

    • XML Generator Transformation

    • Maplet if it contains one of the above transforms

  • You can put the sorted aggregator transformation between the origin sort and the joiner transformation if you use the following guidelines:

    • Configure an aggregator transformation for sorted input.

    • Use the same ports for the column group in the aggregator transform as the ports at the start of the sort.

    • The port group must be in the same order as the ports at the start of the sort.

  • When you join the Joiner transform result set using a different pipeline, make sure the data output from the first Joiner transform is sorted.

    Council. You can place the Joiner transform directly after the sort to preserve the sorted data.

+2


source


Yes, the result is sorted and you can connect it to the joiner using the sorted input. This is one example where Informatica acts slightly differently from Oracle. In SQL, if you pass sorted input and execute a group, the output may not necessarily be sorted.



+1


source






More articles:


All Articles