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
10742 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

More Informatica Interview Questions

How to start a workflow using pmcmd command?

0 Answers

What is data merging, data cleansing and sampling?

6 Answers Satyam,

Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata

1 Answers Cognizant,

What are the types of error logs available in Informatica?

1 Answers

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers TCS,

My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers Amdocs,

Is snow flake or star schema used? If star schema means why?

4 Answers CTS, Sonata,

What is Data Caches size?

0 Answers Informatica,

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers IBM,

what is scd?

6 Answers

a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .

2 Answers TCS,

For more Informatica Interview Questions Click Here