create a mapping to retrieve the employees who are getting salary greater than

create a mapping to retrieve the employees who are getting
salary greater than average salary?

Question Posted / teja_dwh

4 Answers
9253 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

create a mapping to retrieve the employees who are getting salary greater than average salary?..

Answer / shrawan

select employee, salary from table_name
where
salary > ( select avg(salary) from table_name;

Is This Answer Correct ?

7 Yes

2 No

create a mapping to retrieve the employees who are getting salary greater than average salary?..

Answer / sudheer113

go with this order EXP, AGG, JOINER, FILTER

this will work

Is This Answer Correct ?

1 Yes

0 No

create a mapping to retrieve the employees who are getting salary greater than average salary?..

Answer / maxy

I think it's better to have a null check here in the exp
before aggregating.
If salary is Null for any employee it will not be consider
while caculating the avg.
ex-
epm sal
e1 10
e2 20
e3
e4 30

Though there are four employee avg will be 20.

Is This Answer Correct ?

0 Yes

6 No

create a mapping to retrieve the employees who are getting salary greater than average salary?..

Answer / shaik

Source--->EXP--->AGG--->Filter--->Target

by using agg T/f you can find the avg,use that value ti
filter the values by using filter transformation..............

Is This Answer Correct ?

4 Yes

15 No

Post New Answer