By using Transformation i need top most 5 employee salary
from each deptwise? Deptno 10,20,30? which transformation
we need to use?
- 8 Answers
- 16551 Views
- I also Faced
- E-Mail Answers
Answer Posted / kiran
CREATE ONE ROUTER IN THIS CREATE 3 OUTPUT PORTS LIKE DEPT10,DEPT20,DEPT30.THEN OUTPUT OF THIS GIVE TO RANK IN RANK SPECIFY TOP AND NO OF RNAKS 5 THE WE GET EACH DEPT WISE TOP 5 RANKS.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are the different versions of informatica?
What is a joiner transformation?
How are the sources and targets definitions imported in informatica designer?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How to differentiate between the active and passive transformations?
What are the components of workflow manager?
Explain the etl program with few examples.
How to start a workflow using pmcmd command?
Why do we need informatica?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is Cognos script editor?
Enlist few areas or real-time situations where informatica is required.
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain the types of lookup transformation?
