Answer Posted / ankit kansal
Three ways to achieve the result..
1) Sorter Transformation (Distinct Oprtion)
2) Aggregator Transaformation (Group by ALL PORTS)
3) Rank Transformation (Group by ALL) and RNK=1
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the difference between Active and Passive transformation?
difference between informatica 8.1.1 and 8.6
When do you use sql override in a lookup transformation?
permutations of mapplet
How to load the data from a flat file into the target where the source flat file name changes daily?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Which transformation is needed while using the Cobol sources as source definitions?
How might one distinguish in the case of mapping is right or not without associating session?
What is flashback table ? Advance thanks
What is source qualifier transformation in informatica?
which one is better performance wise joiner or look up
How many ways are there to create ports?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is lookup transformation?
How to update source definition?