By using Transformation i need top most 5 employee salary
from each deptwise? Deptno 10,20,30? which transformation
we need to use?
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 informatica metadata?
Is there any target staging area in informatica not staging area
Explain in detail about scd type 1 through mapping.
Enlist the various types of transformations.
what are 3 tech challenges/ common issues you face?
What is different between the data warehouse and data mart?
What are the main features of Oracle 8i with context to datawarehouse?
What is sorter transformation?
What is the cumulative sum and moving sum?
what is song in infrmatica...?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Explain transaction control transformation in informatica
Explain lookup transformation in informatica
What is target designer and target load order?
What is the function of union transformation?