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 |
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
when we use dynamic lookup,if condition matches what will be the o/p?
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
What is the use of incremental aggregation?
Why do we use DSS database for OLAP tools?
In dimension and fact table? which one holds big data?
Explain factlessfact table with scenario
How many ways a relational source definition can be updated and what are they?
Where do we use mapping variables in informatica?
can we import source table without using source qualifier? if yes then how? if no then why?
Which transformation is needed while using the Cobol sources as source definitions?
Explain the types of lookup transformation?