Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / teja_dwh

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

can we override a native sql query within informatica? Where do we do it?

0 Answers  

what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,

In how many ways we can create ports?

0 Answers  

How do you set a varible in incremental aggregation

0 Answers  

Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,

what is the Default Source Option For Update Strategy Transformation?

0 Answers   Informatica,

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

0 Answers  

daily how much amount of data send to production?

4 Answers   HSBC,

How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size

1 Answers  

How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you

5 Answers   Patni,

What is confirmed dimension and fact?

7 Answers  

For more Informatica Interview Questions Click Here
Categories