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

What are the components of workflow manager?

1085


tell me the rules and responsblites in our project(my project is development)

1931


How does the aggregator transformation handle null values?

1145


Is it possible to revert a global repository to local one and why?

1077


Is it possible to use a client with different version than that of its Informatica server?

1132


What is informatica etl tool?

996


How do you load only null records into target?

1211


can u any challenge your project?

2029


explan ur project architecture?

2056


Explain sql transformation in script mode examples in informatica

1125


Performance tuning( what you did in performance tuning)

1975


What is olap (on-line analytical processing?

1063


Can we create two repositories on same database instance in oracle?

1087


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7441


How can you increase the performance in joiner transformation?

1183