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

how to run 2 workflows sequentially. plz respond what is the process?

9 Answers   Cap Gemini, Target,

Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,

how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers   emc2,

expain about the tune parameters?

0 Answers   TCS,

Describe the impact of several join conditions and join order in a joiner transformation?

0 Answers  

How can you define a transformation? What are different types of transformations in Informatica?

10 Answers  

What is the approximate size of data warehouse?

6 Answers   Accenture, i3 Solutions,

Which are the different editions of informatica powercenter that are available?

0 Answers  

difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?

1 Answers   HTC, TCS,

What is the target load order?

3 Answers   HCL, Informatica,

what is the complex transformation you used in informatica

0 Answers   TCS,

After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

3 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories