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 find the 5th highest salary form each department
using 1.SQL Query
2. Informatica power center designer?

Answer Posted / kumar

Can be implemented using RANK Analytic function


http://netezzamigration.blogspot.com/2014/10/analytic-functions-in-netezza.html

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you use reject loader.

2547


How can you validate all mappings in the repository simultaneously?

1290


Explain the etl program with few examples.

968


EXL informatica Questions

1313


How to elaborate powercenter integration service?

1075


Explain in detail scd type 2 through mapping.

991


Implementation methodology

1657


Did u used latest transformations of 8.6.0? for what?

1825


Different circumstance which drives informatica server to expel records?

918


Why sorter is an active transformation?

1130


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2077


What does reusable transformation mean?

1073


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

10633


Where is metadata stored?

1045


What are the different versions of informatica?

1188