Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 19231 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sujana
v can do dis by using rank tranf... grpby dept no and rankindex=5
| Is This Answer Correct ? | 11 Yes | 3 No |
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 |
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 |
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 |
Answer / sujana
@above
in rank also v hav grpby option..no need 2 use aggregator
| Is This Answer Correct ? | 2 Yes | 2 No |
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 |
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 |
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 |
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.
Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?
create a mapping to retrieve the employees who are getting salary greater than average salary?
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
What is aggregator transformation in informatica?
Explain the different dimensions.
without using rank transformation how can we rank items by using some other transformations
How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
what are the deliverables?in your project?
can we use cartesian join in informatica
Teradata 
