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
- 17145 Views
- I also Faced
- E-Mail Answers
Answer Posted / gd
First override source qualifier
Select * from emp where deptno in(10,20,30);
Next sorter T/r sort on salary column desc
Then rank T/r set rank properties top and number of ranks is 5
target achieved
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What is meant by pre and post session shell command?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are the databases that informatica can connect to windows?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Explain load alternative records / rows into multiple targets - informatica
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Differentiate between source qualifier and filter transformation?
define galaxy repository in informatica
COM components can be used in Informatica
Quickly characterize reusable change?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is data caches/ index caches?
What is session task and command task?
What is informatica?
