How to Display top 2 salaries for each department WITHOUT
using Rank Transformation And WITHOUT using SQL queries in
source qualifier.
- 3 Answers
- 18982 Views
- Eureka Forbes, I also Faced
- E-Mail Answers
Answer Posted / ahmed
Use Sorter transformation,apply sort key on sal Col as Desc
and use seq Gen transformation then apply filter on first
two seq numbers...
| Is This Answer Correct ? | 9 Yes | 13 No |
Post New Answer View All Answers
Enlist the advantages of informatica.
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
On which transformations you created partitions in your project?
Explain in detail about scd type 1 through mapping.
What are the transformations that are not supported in mapplet?
what is the Default Source Option For Update Strategy Transformation?
Where can we find the throughput option in informatica?
To import the flat file definition into the designer where should the flat file be placed?
Briefly define a session task?
Explain target update override in informatica
What are the components of Informatica? And what is the purpose of each?
Tell me about Propagate functions in informatica
What are the prerequisite tasks to achieve the session partition?
what is the difference between informatica6.1 and infomatica7.1
What does reusable transformation mean?
