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 is the function of union transformation?

0 Answers  

Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??

3 Answers   IBM,

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  

What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

2 Answers   CTS,

Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,

What is parallel processing in informatica?

0 Answers  

How to go to the older version for a mapping?

0 Answers  

How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,

What are the new features of informatica 9.x at the developer level?

0 Answers  

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,

What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

10 Answers   Deloitte,

Without source how to insert record to target?

6 Answers  

For more Informatica Interview Questions Click Here
Categories