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 / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to load last n records of file into target table - informatica

1050


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1170


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7352


What is the difference between informatica 7.0 and 8.0?

988


What is a pre-defined event and user-defined event?

1025


where to store informatica rejected data? How to extract the informatica rejected data?

984


How do you convert single row from source into three rows into target?

1133


What are the static cache and dynamic cache in informatica?

1168


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2011


What is an unconnected transformation?

1064


can any one give some examples for pre sql and post sql(Except dropping and creating index).

4093


Explain target update override in informatica

1096


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2103


Which version configuration tool used in ur project?

3234


Explain the etl program with few examples.

1028