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

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

1869


Define enterprise data warehousing?

1208


Why filter transformation is an active one?

991


What are active transformations.

1659


How many numbers of sessions can one group in batches?

1065


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2084


What is the commit type if you have a transaction control transformation in the mapping?

1036


What is a filter transformation and why it is an active one?

971


How is union transformation utilized?

1016


Whats the difference between informatica powercenter server, repositoryserver and repository?

1180


Is it possible to create multiple domains on a single Informatica server?

1249


What is the format of informatica objects in a repository?

1022


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2012


COM components can be used in Informatica

2398


 Informatica Checkpoints

3334