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
- 18635 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
Describe an informatica powercenter?
What are connected or unconnected transformations?
What are the transformations that are not supported in mapplet?
what is the hint? how to use it to reduce the query processing in program?
How to do the error handling of if ur source is flatfiles?
What are the differences between oltp and olap?
What are the restrictions of union transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Briefly define a session task?
Explain the different kinds of facts.
What is native users?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is a pre-defined event and user-defined event?
Different sorts of metadata that stores in the storage facility?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
