Interested to Buy Any Domain ? << Click Here >> for more details...
By using Transformation i need top most 5 employee salary
from each deptwise? Deptno 10,20,30? which transformation
we need to use?
- 8 Answers
- 18998 Views
- I also Faced
- E-Mail Answers
Answer Posted / kiran
CREATE ONE ROUTER IN THIS CREATE 3 OUTPUT PORTS LIKE DEPT10,DEPT20,DEPT30.THEN OUTPUT OF THIS GIVE TO RANK IN RANK SPECIFY TOP AND NO OF RNAKS 5 THE WE GET EACH DEPT WISE TOP 5 RANKS.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How to load last n records of file into target table - informatica
What is the difference between informatica 7.0 and 8.0?
How can we use mapping variables in informatica? Where do we use them?
What is rank transformation in informatica
Mention some types of transformation?
What is xml source qualifier transformation in informatica?
Briefly describe lookup transformation?
What are the data movement modes in informatica?
where to store informatica rejected data?
What do you understand by SOA of Informatica?
In informatics server which files are created during the session rums?
Is stop and abort are same in informatica?
can we override a native sql query within informatica? Where do we do it?
what is informatica metadata?
What is sorter transformation?
