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

What are the different ways to implement parallel processing in informatica?

1483


What is status code in informatica?

1065


Design a mapping to load the cumulative sum of salaries of employees into target table?

1557


What is a mapplet/worklet in informatica?

1245


How to do unit testing in informatica?

1229


generate date / time dimension in informatica

1164


Differentiate between router and filter transformation?

1066


What is a joiner transformation?

1037


tell me about your project functionality

2383


What is meant by lookup transformation? Explain the types of lookup transformation?

1022


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5880


What are the different options available for update strategy?

1054


write a query to retrieve the latest records from the table sorted by version(scd)

1122


explain abt ur project architecture?

2235


expain about the tune parameters?

2458