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 pmcmd command?
What are the main issues while working with flat files as source and as targets ?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What are session parameters ? How do you set them?
How can we update a record in the target table without using update strategy?
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.
What are the measure objects?
Describe data concatenation?
What is expression transformation?
What is an expression transformation?
What is a mapplet/worklet in informatica?
Describe an informatica powercenter?
what is the hint? how to use it to reduce the query processing in program?
What is meant by pre and post session shell command?
How to partition the Session?