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
What are the different ways to implement parallel processing in informatica?
What is status code in informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is a mapplet/worklet in informatica?
How to do unit testing in informatica?
generate date / time dimension in informatica
Differentiate between router and filter transformation?
What is a joiner transformation?
tell me about your project functionality
What is meant by lookup transformation? Explain the types of lookup transformation?
-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?
What are the different options available for update strategy?
write a query to retrieve the latest records from the table sorted by version(scd)
explain abt ur project architecture?
expain about the tune parameters?