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

What is meant by pre and post session shell command?

1200


what is index?how it can work in informatica

2083


What are the popular informatica products?

1056


What is a sorter transformation?

1156


Could you explain what is enterprise data warehouse?

1224


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

1052


How to load last n records of file into target table - informatica

1133


Differentiate between reusable transformation and mapplet.

1142


What is the difference between writing a joiner query in ANSI style and THETA style?

2436


What is rank transform?

1061


what is degenerated dimension?

4093


What is Index Caches size?

1163


How to convert multiple rows to single row (multiple columns) in informatica

1426


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1947


Define Pmrep command?

1113