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

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 Answers  

What is the default source option for update stratgey transformation?

1 Answers  

What are mapplets? How is it different from a Reusable Transformation?

0 Answers   Informatica,

In warehouses how many schemas are there?

0 Answers  

star and snowflake schema?

6 Answers  

How can we handle two sessions in informatica?

0 Answers  

When the informatica server marks that a batch is failed?

1 Answers  

explan ur project architecture?

0 Answers   TCS,

What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,

What is flashback table ? Advance thanks

0 Answers   Puma,

Please let me know how to make Data masking in informatica..

0 Answers  

What is source qualifier?

6 Answers   SDS,