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
- 20701 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 |
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
How do you load alternate records into different tables through mapping flow?
why we use datawarehouse
Target is zero file and how can you send the email?
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
What are the parts of Informatica Server?
How to convert multiple rows to single row (multiple columns) in informatica
How can we use mapping variables in informatica? Where do we use them?
What are the types of presistent cache in look up tr.
What does update strategy mean, and what are the different option of it?
How to import oracle sequence into Informatica?
Mention some types of transformation?
Teradata 
