Hi ,
why don't break up the mapping in two mappings which will be simpler i guess.
The first mapping will do the insertion in two tables, and the second mapping will do an update depending up the target table.
Pls give a try and see.
-Prashanth
Hi Hitesh,
Try using the sorted input option in source qualifier.
If sorted option is used then the Informatica server assumes that all data entering an Aggregator transformation are already sorted into groups that correspond to the Aggregator’s “Group By” ports. As a result, the server does...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.