Answer / sujana

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

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.

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)

Answer / suguna

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

Answer / sujana

@above

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

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

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

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

What is the target load order?

3 Answers   HCL, Informatica,

what is data driven?

1 Answers  

In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?

4 Answers  

Hey I am net to informatica? Can any one explain me step by step How scd will work ?

1 Answers   Infosys,

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

5 Answers   Accenture,

tell me the informatica architecture

1 Answers   Banca Sella, Wipro,

what is flat file override?

1 Answers   Cap Gemini, HP,

How to update source definition?

0 Answers  

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,

Is it possible to have "5 source & 5 Target" in single mapping?

1 Answers  

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,

What is workflow? What are the components of workflow manager?

0 Answers