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?
- 4 Answers
- 26033 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
What is a repository? And how to add it in an informatica client?
What is the surrogate key?
Explain direct and indirect flat file loading (source file type) - informatica
Sequence generator, when you move from develoment to production how will you reset
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is a router transformation?
What could be the possible resons of locks by user?
Is it possible to create multiple domains on a single Informatica server?
Explain pmcmd command usage in informatica
how to load dimension table and fact table. plz tell me the steps.
How to update a particular record in target with out running whole workflow?
What are the tasks that source qualifier perform?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How can repository reports be accessed without sql or other transformations?
what is mean by complex business rule ?
