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 different types of Type2 dimension maping?

1 Answers  

What are the types of presistent cache in look up tr.

0 Answers   IBM,

what are the settiings that u use to cofigure the joiner transformation?

2 Answers  

what is lookupoverriding?

1 Answers  

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

1 Answers   TATA,

Explain why we use partitioning the session in informatica?

0 Answers  

tell me the rules and responsblites in our project(my project is development)

0 Answers  

What are the tasks that source qualifier perform?

0 Answers   Informatica,

Does Facttable Normalized or Denormalized?

2 Answers   IBM,

can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?

1 Answers   Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,

How does the aggregator transformation handle null values?

0 Answers  

For more Informatica Interview Questions Click Here
Categories