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
v can do dis by using rank tranf... grpby dept no and rankindex=5
Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
What is meant by lookup transformation? Explain the types of lookup transformation?
Explain the etl program with few examples.
Explain Dataware house architecture .how data flow from intial to end?
How can we use mapping variables in informatica?
What is the session task and command task?
what is song in infrmatica...?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Differences between version 7.x and 8.x.
Why union transformation is an active transformation?
What are ETL Tools?
Parameter and variable differences
4 yrs etl devloper roles and responsibilities?any body give solutions
What is DR strategy for Informatica project?
Explain sessions. Explain how batches are used to combine executions?
Explain sessions?