How to Display top 2 salaries for each department WITHOUT
using Rank Transformation And WITHOUT using SQL queries in
source qualifier.
- 3 Answers
- 20775 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 are some examples of informatica etl programs?
How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica
can you use flat file for repository?why?
If I have a index defined on target table and if set it to bulk load will it work ?
What is staging area?
what is scd?
Explain the different dimensions.
what is upstream and downstream transformation?
When you move from devel to prod how will you retain a variable
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
What is the function of look up transformation?
What are the joiner caches?
Teradata 
