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 do you load alternate records into different tables through mapping flow?

1819


Can we get 1st record through Informatica(without sequence number).

1429


How many types of sessions are there in informatica.please explain them?

1125


Enterprise data warehouse your projects phase by phase explain?

1869


What is confirmed fact in dataware housing?

6846


Explain informatica architecture - version 8 / 9

1043


Why union transformation is an active transformation?

1003


What are the advantages of informatica?

967


Different qualification between a related rotate toward the sky and isolates look upward?

948


What is meant by target load plan?

929


Write the program through which the records can be updated?

949


wat are deployement groups in informatica, how it will be used for developers

1683


What are the limitations of joiner transformation?

1059


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2485


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2038