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
What is meant by pre and post session shell command?
what is index?how it can work in informatica
What are the popular informatica products?
What is a sorter transformation?
Could you explain what is enterprise data warehouse?
What are the new features of informatica 9.x in developer level?
How to load last n records of file into target table - informatica
Differentiate between reusable transformation and mapplet.
What is the difference between writing a joiner query in ANSI style and THETA style?
What is rank transform?
what is degenerated dimension?
What is Index Caches size?
How to convert multiple rows to single row (multiple columns) in informatica
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Define Pmrep command?