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
Define pmcmd command?
What is a difference between complete, stop and abort?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is difference between a gateway node and worker node?
What are the measure objects?
What is data movement mode in Informatica and difference between them?
What is enterprise data warehousing?
What is the use of transformation?
what is the difference between informatica6.1 and infomatica7.1
Explain incremental aggregation in informatica
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is native users?
what is index?how it can work in informatica
What are the types of presistent cache in look up tr.
Clarify the utilization of aggregator cache record?