How to Display top 2 salaries for each department WITHOUT
using Rank Transformation And WITHOUT using SQL queries in
source qualifier.
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 a filter transformation and why it is an active one?
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
What is Java Transformation? what are the uses of it?
where to store informatica rejected data?
what is Partitioning ? where we can use Partition?
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
What are ETL Tools?
How do you load only null records into target?
What are the parts of Informatica Server?
What is the difference between Bitmap and Btree index?
What is Code Page Compatibility?