By using Transformation i need top most 5 employee salary
from each deptwise? Deptno 10,20,30? which transformation
we need to use?
- 8 Answers
- 16618 Views
- I also Faced
- E-Mail Answers
Answer Posted / suguna
by using rank transformation rank of salary and aggregator
transformation for group by dept wise
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
Can we change Dynamic to Static or Persistent cache? If so what happens?
Mention a few design and development best practices for informatica?
How do you update the records with or without using update strategy?
What are the measure objects?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the modules in Power Center
Why is sorter an active transformation?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Explain the etl program with few examples.
tell me about your project functionality
How to improve the performance of a session using sorter transformation?
What are the restrictions of union transformation?
wat are deployement groups in informatica, how it will be used for developers
Is there any way to read the ms excel datas directly into informatica?
