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

how to get max value record into one target and remaining
records into another target?

Answer Posted / informatica

use a sorter and do a descending sort. calculate the row_id.
pass it to a router. 1 group condition will be row_id=1.
2nd group row_id >1.1st group to one target instance. 2nd
group to another target instance.

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 you generate reports in informatica?

1083


How do you remove duplicate records in informatica? And how many ways are there to do it?

1207


can we override a native sql query within informatica? Where do we do it? How do we do it?

1115


What is the meaning of up gradation of repository?

2055


How can a transformation be made reusable?

1238


in reporting we add some new objects,how we get the count of the newly added objects to the report

2252


 Informatica Checkpoints

3378


Explain why we use partitioning the session in informatica?

1164


How do you manage the Parameter files while migrating your data from one environment to another environment?

1069


What is the use of an aggregator cache file?

1249


What do you understand by term role-playing dimension?

1118


What are different types of transformations available in informatica?

1060


What are the components of workflow manager?

1159


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

4780


What is aggregator transformation in informatica?

1006