How to Display top 2 salaries for each department WITHOUT
using Rank Transformation And WITHOUT using SQL queries in
source qualifier.
Answer Posted / dave
Use Aggregator as Transformation with MAX and 2 outputs
Is This Answer Correct ? | 0 Yes | 10 No |
Post New Answer View All Answers
How you prepared reports for OLAP?
What all are steps in up gradation of Informatica server?
What does command task mean?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are the advantages of using informatica as an etl tool over teradata?
While migrating the data from one environment to another environment how would you manage the connections?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is informatica?
What is domain in terms of informatica?
What is the use of source qualifier?
Explain lookup transformation is active in informatica
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is the difference between STOP and ABORT options in Workflow Monitor?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Define pmcmd command?