Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

Define maping and sessions?

3 Answers  

WHAT IS FACT TABLES?

2 Answers  

How to extract sap data using informatica? What is abap? What are idocs?

0 Answers  

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 Answers  

Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,

A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 Answers  

Define sessions in informatica etl?

0 Answers  

Define Incremental Aggregation?

2 Answers  

how can we perform incremental aggregation?explain with example?

9 Answers   IBM, TCS,

Could any one to tell How to use the Oracle Analytic functions in Informatica?

1 Answers  

What are the performance considerations when working with aggregator transformation?

0 Answers  

What is lookup change?

0 Answers  

For more Informatica Interview Questions Click Here
Categories