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

As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 Answers  

how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....

4 Answers   TCS,

Explain the features of connected and unconnected lookup.

0 Answers  

In dimension and fact table? which one holds big data?

2 Answers  

Reusable transformation and shortcut differences

0 Answers  

How can we delete duplicate rows from flat files?

0 Answers  

How can we store previous session logs?

0 Answers  

can u give example for factless fact table

2 Answers   TCS,

how many session run unix environment what command using ?

1 Answers   HCL,

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

Which transformation should u need while using the cobol sources as source defintions?

2 Answers