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


Please Help Members By Posting Answers For Below Questions

What is pmcmd command?

665


What are the main issues while working with flat files as source and as targets ?

643


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

623


What are session parameters ? How do you set them?

1369


How can we update a record in the target table without using update strategy?

646






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.

1751


What are the measure objects?

651


Describe data concatenation?

563


What is expression transformation?

623


What is an expression transformation?

586


What is a mapplet/worklet in informatica?

678


Describe an informatica powercenter?

602


what is the hint? how to use it to reduce the query processing in program?

6271


What is meant by pre and post session shell command?

610


How to partition the Session?

638