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

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2252


update strategy transformation in informatica

1014


What are the different options available for update strategy?

938


How can you generate reports in informatica?

972


What are mapplets?

1212


What is deployment group?

1129


What all join we can perform in LOOKUP transformation?

913


hi real timers . iam waiting for ur reply regarding ETL TESTING

2207


What is joiner transformation in informatica?

993


Briefly explain the aggregator transformation?

942


what is size of u r database?

2246


What is an Integration service in Informatica?

1081


Explain the scenario which compels informatica server to reject files?

1088


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

1015


How to do unit testing in informatica?

1122