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
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)
what is index?how it can work in informatica
what is diff b/t sorter t/r and agg have the option sorter property...
Different sorts of metadata that stores in the storage facility?
What are multi-group transformations?
What is a joiner transformation and why it is an active one?
can anyone suggest best free Talend data integration training online
EXL informatica Questions
Explain lookup transformation in informatica
What are the types of caches in lookup?
Differences between connected and unconnected lookup?
What are the guidelines to be followed while using union transformation?
Explain in detail about scd type 1 through mapping.
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Make a note of the quantity vaults made in informatica?