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
- 20545 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 are the settings that you use to configure the joiner transformation?
Where are the source flat files kept before running the session?
How to load a Dimension ? and how to load a fact table?
What do you mean by channel change?
What is a pre-defined event and user-defined event?
What is repository manager?
What is the benefit of partitioning a session?
How do you convert single row from source into three rows into target?
differences between service based and product based?
Partition, what happens if the specified key range is shorter and longer
How can you differentiate between powercenter and power map?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How to extract sap data using informatica? What is abap? What are idocs?
Write the program through which the records can be updated?
What the difference is between a database, a data warehouse and a data mart?
