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

What is the fact table?

0 Answers  

enterprise datawarehouse your project phase by phase explain?

1 Answers   Cap Gemini,

Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

5 Answers   Flextronics,

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

Define Incremental Aggregation?

2 Answers  

how to obtain performance data for individual transformations.

2 Answers  

how did u understand business requirement?

2 Answers   TCS,

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,

By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 Answers  

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,

What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,

what is song in infrmatica...?

0 Answers   CTS,

For more Informatica Interview Questions Click Here
Categories