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
What is a connected transformation?
What is the maplet?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What are the advantages of using informatica as an etl tool over teradata?
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.
scenario where i can use only concurrent execution of workflow.
Explain what is informatica metadata and where is it stored?
How to create a non-reusable instance of reusable transformations?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
design of staging area?
How does the aggregator transformation handle null values?
What are batches?
What is a node in Informatica?
What is different between the data warehouse and data mart?
How union transformation is used?