How to Display top 2 salaries for each department WITHOUT
using Rank Transformation And WITHOUT using SQL queries in
source qualifier.
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
Can we create multiple integration service on single repository?
What is the use of code page?
Can you use flat files in Mapplets.
How do you load unique records into one target table and duplicate records into a different target table?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Informatica Checkpoints
explan ur project architecture?
What is the way to execute pl/sql script using informatica mapping?
server hot-ws270 is connect to Repository B. What does it mean?
What is standalone command task?
Differences between version 7.x and 8.x.
Slowly changing dimensions, types and where will you use them
How to delete duplicate row using informatica?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How do you change a non-reusable transformation to reusable transformation?