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
- 19184 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 is song in infrmatica...?
What is target load order?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is decode in static cache?
What are the various types of transformation?
Partition, what happens if the specified key range is shorter and longer
what is degenerated dimension?
Is there any target staging area in informatica not staging area
Explain why we use partitioning the session in informatica?
How can we use batches?
I have a flat file, want to reverse the contents of the flat file
What is Session and Batches?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
expain about the tune parameters?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
