By using Transformation i need top most 5 employee salary
from each deptwise? Deptno 10,20,30? which transformation
we need to use?

Answers were Sorted based on User's Feedback



By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? whi..

Answer / sujana

v can do dis by using rank tranf... grpby dept no and rankindex=5

Is This Answer Correct ?    11 Yes 3 No

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? whi..

Answer / 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

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? whi..

Answer / ashwin

A simple way is here:
1: Drag & drop source and target
2: Create a Rank Transformation in between them
3: Open the rank t/r & go to Ports
4: Give Sal as 'R'(Rank) & Tick Group by on Deptno
5: Goto Properties select Top/Bottom,No.of Ranks=(as you need)

Is This Answer Correct ?    1 Yes 0 No

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? whi..

Answer / suguna

by using rank transformation rank of salary and aggregator
transformation for group by dept wise

Is This Answer Correct ?    4 Yes 4 No

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? whi..

Answer / sujana

@above

in rank also v hav grpby option..no need 2 use aggregator

Is This Answer Correct ?    2 Yes 2 No

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? whi..

Answer / jay

Override SQL in source qualifies with bellow query

Select Top 5 EmpNo, DeptNo, Sal from Employee where DeptNo = 10 order by Sal desc

Union All

Select Top 5 EmpNo, DeptNo, Sal from Employee where DeptNo = 20 order by Sal desc


Union All

Select Top 5 EmpNo, DeptNo, Sal from Employee where DeptNo = 30 order by Sal desc

Is This Answer Correct ?    1 Yes 2 No

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? whi..

Answer / 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

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? whi..

Answer / jay

Override SQL in source qualifies with bellow query

Select Top 5 EmpNo, DeptNo, Sal from Employee where DeptNo = 10 order by Sal desc

Union All

Select Top 5 EmpNo, DeptNo, Sal from Employee where DeptNo = 20 order by Sal desc


Union All

Select Top 5 EmpNo, DeptNo, Sal from Employee where DeptNo = 20 order by Sal desc

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 Answers   Accenture,


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

0 Answers   Bosch,


Which transformation should we use to normalize the COBOL and relational sources?

4 Answers   DELL, IBM, Lehman Brothers,


How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,


From where we can start or use pmcmd?

3 Answers  






HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,


WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.

2 Answers  


how to sort date field in infomatica?

2 Answers  


I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers  


What is deployemnt groups, Lables, query and dynamic deployment group.

1 Answers   IBM, SVP,


Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,


Define the various join types of joiner transformation?

0 Answers  


Categories