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
- 19222 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 are connected or unconnected transformations?
What is a joiner transformation and why it is an active one?
Why filter transformation is an active one?
What are the different transaction levels available in transaction control transformation?
What is intricate mapping?
Differentiate between sessions and batches?
What are active and passive transformations?
Explain the code page compatibility?
r u done any partitions in ur project?
What is joiner change?
What is a shortcut and copy in Informatica and how two are different with each other?
What are the informatica performance improvement tips
What is the difference between router and filter?
Explain about Informatica server process that how it works relates to mapping variables?
How can you differentiate between powercenter and power map?
