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
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
how many types of dimensions are available in informatica?
What is a node in Informatica?
What are Dimensional table?
What is a dimensional model?
What do you mean by blocking transformation?
What is source qualifier transformation in informatica?
How to handle decimal places while importing a flatfile into informatica?
How to load the data from a flat file into the target where the source flat file name changes daily?
What are the advantages of using informatica as an etl tool over teradata?
What is resilience time?
How do you use reject loader.
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is decode in static cache?
what is INFORMATICA TESTING process