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 CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND
REMAINING TO OTHER TARGET?

Answer Posted / vino

you can give the next val of the seq generator to the
expression which produces a sequence for all the incoming
records.then create an output port in the expression with
the calculation (incoming_seq mod 2) which will produce
either 0 or 1..then after that use a router creating groups
1 and 0...then load into the 2 targets.

Is This Answer Correct ?    5 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1628


what is index?how it can work in informatica

2041


what is diff b/t sorter t/r and agg have the option sorter property...

2179


Different sorts of metadata that stores in the storage facility?

1012


What are multi-group transformations?

1103


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

1083


can anyone suggest best free Talend data integration training online

1691


EXL informatica Questions

1391


Explain lookup transformation in informatica

1073


What are the types of caches in lookup?

1050


Differences between connected and unconnected lookup?

1219


What are the guidelines to be followed while using union transformation?

1144


Explain in detail about scd type 1 through mapping.

1555


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

1059


Make a note of the quantity vaults made in informatica?

988