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
- 20526 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 active transformations.
What is meant by lookup transformation?
Clarify the aggregator change?
Reusable transformation and shortcut differences
how to load dimension table and fact table. plz tell me the steps.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
tell me the rules and responsblites in our project(my project is development)
What is an expression transformation?
Explain the types of lookup transformation?
What is the reusable transformation?
What does update strategy mean, and what are the different option of it?
How can we handle two sessions in informatica?
What is source qualifier transformation in informatica?
What is the cumulative sum and moving sum?
what are the deliverables?in your project?
