i have flatfile source. i want to load the maximum salary of each deptno into t

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

Question Posted / guest

3 Answers
10350 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / pradeepa

We can use an aggregator to group by on deptno and create a
newport to find the max(salary) and load dept no and
salary,we'll get unique deot no and the max salary.

Is This Answer Correct ?

15 Yes

0 No

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

Answer / syed

we can also use rank transformation by setting top, no of
rank =1 and enable group by port deptno

Is This Answer Correct ?

9 Yes

2 No

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

Answer / janardhanreddy yerraballi

select deptid, empname, salary from
(Select deptid, empname,salary,
rank() Over(Partition by deptid order by salary desc)as rank from
EmpDetails) emp
where emp.rank = 1

Is This Answer Correct ?

1 Yes

0 No

Post New Answer