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
How do you use reject loader.
How can you validate all mappings in the repository simultaneously?
Explain the etl program with few examples.
EXL informatica Questions
How to elaborate powercenter integration service?
Explain in detail scd type 2 through mapping.
Implementation methodology
Did u used latest transformations of 8.6.0? for what?
Different circumstance which drives informatica server to expel records?
Why sorter is an active transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What does reusable transformation mean?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Where is metadata stored?
What are the different versions of informatica?