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 / gd
First override source qualifier
Select * from emp where deptno in(10,20,30);
Next sorter T/r sort on salary column desc
Then rank T/r set rank properties top and number of ranks is 5
target achieved
Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What are the different transaction levels available in transaction control transformation?
What do think which one is the better joiner or look up?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What are the components of the workflow manager?
Different circumstance which drives informatica server to expel records?
What's the layout of parameter file (what does a parameter file contain?)?
What is olap (on-line analytical processing?
What is standalone command task?
Explain Dataware house architecture .how data flow from intial to end?
How to extract sap data using informatica?
Design time, run time. If you don't create parameter what will happen
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain joiner transformation in informatica
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 is an Integration service in Informatica?