how to find the 5th highest salary form each department
using 1.SQL Query
2. Informatica power center designer?
- 4 Answers
- 25115 Views
- CTC, I also Faced
- E-Mail Answers
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
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Write the different tools in the workflow manager?
Have you worked with/created Parameter file
Scheduling properties,whats the default (sequential)
On which transformations you created partitions in your project?
How can a transformation be made reusable?
Briefly define reusable transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How you can differentiate between connected lookup and unconnected lookup?
How might you approve all mappings in the archive all the while?
What is the meaning of up gradation of repository?
What is domain and gateway node?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
