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
Where are the source flat files kept before running the session?
Under what condition selecting sorted input in aggregator may fail the session?
What could be the possible resons of locks by user?
Enlist the differences between database and data warehouse.
What is the session task and command task?
What are the different lookup cache(s)?
Where do we use mapping variables in informatica?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is rank transform?
Explain pmcmd command usage in informatica
How to create Target definition for flat files?
Did u used latest transformations of 8.6.0? for what?
pmscmd startworkflow -sv
Explain sessions and how many types of sessions are there?
can you please explain me pre session and post session options?