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

i have flatfile source. i want to load the maximum salary of
each deptno into target. what isthe mapping flow

Answer Posted / pradeepa

We can use an aggregator to group by on deptno and create a
newport to find the max(salary) and load dept no and
salary,we'll get unique deot no and the max salary.

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we update a record in the target table without using update strategy?

1094


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1817


What is decode in static cache?

1096


What is union transformation?

917


Which is the t/r that builts only single cache memory?

1136


How to create the source and target database connections in server manager?

1041


How can informatica be used for an organization?

1141


Explain your project of banking domian.

1617


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4686


Name the different lookup cache(s)?

1168


Enterprise data warehouse your projects phase by phase explain?

1869


Does an informatica transformation support only aggregate expressions?

981


How can one identify whether mapping is correct or not without connecting session?

1381


Explain scd type 3 through mapping.

926


Describe the impact of several join conditions and join order in a joiner transformation?

1018