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
- 17609 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 are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is the function of aggregator transformation?
What are the types of presistent cache in look up tr.
Differentiate between reusable transformation and mapplet.
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Mention few advantages of router transformation over filter transformation.
How can you increase the performance in joiner transformation?
When do you use sql override in a lookup transformation?
What is the difference between a repository server and a powerhouse?
Partition, what happens if the specified key range is shorter and longer
Explain Dataware house architecture .how data flow from intial to end?
What is the difference between a connected look up and unconnected lookup?
What are active and passive transformations?
