Interested to Buy Any Domain ? << Click Here >> for more details...
How to Display top 2 salaries for each department WITHOUT
using Rank Transformation And WITHOUT using SQL queries in
source qualifier.
- 3 Answers
- 20536 Views
- Eureka Forbes, I also Faced
- E-Mail Answers
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 an unconnected transformation?
What is dimensional table?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Differentiate between source qualifier and filter transformation?
can u any challenge your project?
What is source qualifier transformation in informatica?
What are the components of Informatica? And what is the purpose of each?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is confirmed fact in dataware housing?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
update strategy transformation in informatica
In informatica workflow manager, how many repositories can be created?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are the different options available for update strategy?
