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
- 18888 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
How can you differentiate between powercenter and power map?
how to load dimension table and fact table. plz tell me the steps.
What are the designer tools for creating transformations?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is lookup change?
Define enterprise data warehousing?
Explain the types of transformations?
generate date / time dimension in informatica
What is a router transformation?
What is olap (on-line analytical processing?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How to differentiate between the active and passive transformations?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is the use of source qualifier?
What is informatica powercenter repository?
