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

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

706


can anyone suggest best free Talend data integration training online

1274


in reporting we add some new objects,how we get the count of the newly added objects to the report

1764


How do you use reject loader.

2080


How does the aggregator transformation handle null values?

711






How to create or import flat file definition in to the warehouse designer?

624


What does command task mean?

622


Briefly define a session task?

599


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

1269


Scheduling properties,whats the default (sequential)

1482


Where are the source flat files kept before running the session?

636


How to extract sap data using informatica?

616


What are the different transaction levels available in transaction control transformation?

686


Is there any way to read the ms excel datas directly into informatica?

558


What is deployment group?

696