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

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

Answer Posted / sudheer113

go with this order EXP, AGG, JOINER, FILTER

this will work

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you promote a non-reusable transformation to reusable transformation?

1136


What are the types of lookup transformation?

1074


What is the use of transformation?

994


list out all the transformations which use cache?

1180


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1246


what are 3 tech challenges/ common issues you face?

2346


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2280


What are the different ways to implement parallel processing in informatica?

1423


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2177


Is it possible to define a single node as a Gateway node as well as worker node?

1121


How to generate sequence numbers without using the sequence generator transformation?

1205


Explain the types of lookup transformation?

1043


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1275


In warehouses how many schemas are there?

1070


Write the advantages of partitioning a session?

1278