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
- 18964 Views
- I also Faced
- E-Mail Answers
Answer Posted / ashwin
A simple way is here:
1: Drag & drop source and target
2: Create a Rank Transformation in between them
3: Open the rank t/r & go to Ports
4: Give Sal as 'R'(Rank) & Tick Group by on Deptno
5: Goto Properties select Top/Bottom,No.of Ranks=(as you need)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is transformation?
What is the status code in stored procedure transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are the advantages of informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
In informatica workflow manager, how many repositories can be created?
How can you increase the performance in joiner transformation?
What are the main features of Oracle 8i with context to datawarehouse?
What are the new features of informatica 9.x at the developer level?
What are junk dimensions?
How can we use batches?
What is a predefined event?
Mention a few design and development best practices for informatica?
What is a standalone command task?
Why sorter is an active transformation?
