By using Transformation i need top most 5 employee salary
from each deptwise? Deptno 10,20,30? which transformation
we need to use?
Answer Posted / sujana
@above
in rank also v hav grpby option..no need 2 use aggregator
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is a difference between complete, stop and abort?
What is joiner transformation?
What happens when a session fails and you click on recover?
Define mapplet?
How many number of sessions can one group in batches?
While migrating the data from one environment to another environment how would you manage the connections?
Explain sessions. Explain how batches are used to combine executions?
what are the deliverables?in your project?
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?
How do we call shell scripts from informatica?
I have a flat file, want to reverse the contents of the flat file
How do you load unique records into one target table and duplicate records into a different target table?
Explain the different kinds of facts.
Reusable transformation and shortcut differences
What is the use of code page?