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
- 18637 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
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is the sequence generator transformation in informatica?
Describe an informatica powercenter?
State the differences between sql override and lookup override?
What are active and passive transformations?
Can informatica load heterogeneous targets from heterogeneous sources?
Plz can any one say me how to get the informatica certification materials and dumps
What is an aggregator transformation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How do you take back up of repository?
how to create user defined function (udf) in informatica
What do you understand by term role-playing dimension?
What is a code page?
can u give example for factless fact table
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
