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...

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

Answer Posted / dave

Use Aggregator as Transformation with MAX and 2 outputs

Is This Answer Correct ?    0 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a connected transformation?

1046


What is the maplet?

1040


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2276


What are the advantages of using informatica as an etl tool over teradata?

968


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2292


scenario where i can use only concurrent execution of workflow.

3061


Explain what is informatica metadata and where is it stored?

987


How to create a non-reusable instance of reusable transformations?

1057


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10629


design of staging area?

1963


How does the aggregator transformation handle null values?

1084


What are batches?

1010


What is a node in Informatica?

1002


What is different between the data warehouse and data mart?

1000


How union transformation is used?

954