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
- 18962 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 degenerated dimension?
What are the different components of powercenter?
What is target designer and target load order?
What is the sequence generator transformation in informatica?
What is a code page?
How to do unit testing in informatica? How to load data in informatica ?
How to handle decimal places while importing a flatfile into informatica?
What are the guidelines to be followed while using union transformation?
What is the difference between Active and Passive transformation?
pmscmd startworkflow -sv
What is decode in informatica?
What are the various types of transformation?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What do you understand by a term domain?
What is the use of transformation?
