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
- 18963 Views
- I also Faced
- E-Mail Answers
Answer Posted / suguna
by using rank transformation rank of salary and aggregator
transformation for group by dept wise
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What is the function of aggregator transformation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How an expression transformation differs from aggregator transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the tasks that can be performed using sq?
What is the advantage of informatica?
What is the difference between writing a joiner query in ANSI style and THETA style?
How are indexes created after completing the load process?
What is joiner transformation in informatica?
What is the difference between informatics 7x and 8x and what is latest version?
Can we get 1st record through Informatica(without sequence number).
How to generate sequence numbers using expression transformation?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the difference between stop and abort in informatica
What are the different types of olap? Give an example?
