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.
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]
In unconnected lookup, what are the other transformations that can be used in place of that expression transformation?
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?
Can two flat files be joined with Joiner Transformation using informatica?