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
- 20693 Views
- Eureka Forbes, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / dave
Use Aggregator as Transformation with MAX and 2 outputs
| Is This Answer Correct ? | 0 Yes | 10 No |
What is target load order?
How you can differentiate between connected lookup and unconnected lookup?
what are the transformations that restricts the partitioning of sessions?
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
What are the types of error logs available in Informatica?
How to generate sequence numbers using expression transformation?
How many types of sessions are there in informatica.please explain them?
What is rank transformation?
Write the unconnected lookup syntax?
Explain lookup transformation is active in informatica
what is data modelling? what are types of modelling?In which suituation will use each one?
How to create the source and target database connections in server manager?
Teradata 
