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 if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
What is a shortcut and copy in Informatica and how two are different with each other?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste
Different sorts of metadata that stores in the storage facility?
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
what is the logic will you implement to load data into a fact table from n dimension tables?
how will you get 21 to 30 record from 50 records?