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
- 20514 Views
- Eureka Forbes, I also Faced
- E-Mail Answers
Answer Posted / harish konda
connect the Source to sorter and sort the data in Descending
order of salary, department and connect to expression and in
expression generate the sequence of numbers(for eg a port
flag) in such a way that whenever salary changes number
increment to 1, and keep in mind whenever department changes
the numbering should start from 1. And next connect the exp
to Filter and give condition as flag<=2.
| Is This Answer Correct ? | 18 Yes | 2 No |
Post New Answer View All Answers
What is persistent lookup cache?
Can anyone tell me the new features in Informatica 9 Version?
Slowly changing dimensions, types and where will you use them
What are the features of complex mapping?
Repository user profiles
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is target designer and target load order?
What is the use of source qualifier?
What are data-driven sessions?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Define filter transformation?
What are the prerequisite tasks to achieve the session partition?
What are the components of Informatica? And what is the purpose of each?
What is pmcmd command?
What are the different transaction levels available in transaction control transformation?
