Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

How to Display top 2 salaries for each department WITHOUT
using Rank Transformation And WITHOUT using SQL queries in
source qualifier.

Question Posted / rajan

Answers were Sorted based on User's Feedback



How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT us..

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

How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT us..

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

How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT us..

Answer / dave

Use Aggregator as Transformation with MAX and 2 outputs

Is This Answer Correct ?    0 Yes 10 No

Post New Answer

More Informatica Interview Questions

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.

3 Answers   Amdocs, Deloitte,

why dimenstion tables are denormalized in nature ?

3 Answers  

can anyone explain me about sales project in informatica?

8 Answers   MBT, Satyam,

write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5

2 Answers   TCS,

how can you load data into target table without leading zeor's

4 Answers   Deloitte,

Explain the code page compatibility?

0 Answers  

How are the sources and targets definitions imported in informatica designer?

0 Answers   Informatica,

What is Target Update Override? What is the Use ?

8 Answers   Patni,

what are types of dimentions?

3 Answers  

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

3 Answers  

In ur current projectu have done any performance tuning of mappings?

1 Answers  

What are data-driven sessions?

0 Answers  

For more Informatica Interview Questions Click Here
Categories