top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Transformations that cannot be placed between the sort origin and the Joiner transformation

+1 vote
1,016 views

What are the transformations that cannot be placed between the sort origin and the Joiner transformation so that we do not lose the input sort order.

posted Jan 12, 2016 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

The best option is to place the Joiner transformation directly after the sort origin to maintain sorted data. However do not place any of the following transformations between the sort origin and the Joiner transformation:
Custom
* UnsortedAggregator
* Normalizer
* Rank
* Union transformation
* XML Parser transformation
* XML Generator transformation
* Mapplet [if it contains any one of the above mentioned transformations]

answer Jan 12, 2016 by Shivaranjini
Similar Questions
+2 votes

In unconnected lookup, what are the other transformations that can be used in place of that expression transformation?

+2 votes

What is the difference between Joiner and Union Transformation? Also, Should we use Router instead of Joiner, to increase performance when there are multiple sources?

+2 votes

Can two flat files be joined with Joiner Transformation using informatica?

...