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?
- 6 Answers
- 11400 Views
- I also Faced
- E-Mail Answers
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 types of caches in lookup? Explain them.
what is INFORMATICA TESTING process
How you know when to use a static cache and dynamic cache in lookup transformation?
What are junk dimensions?
What are the reusable transformations?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How to update source definition?
What is a stored procedure transformation?
What are the performance considerations when working with aggregator transformation?
How might one distinguish in the case of mapping is right or not without associating session?
Explain lookup transformation source types in informatica
What are the guidelines to be followed while using union transformation?
Explain the etl program with few examples.
What is a dimensional model?
What are the settings that you use to configure the joiner transformation?
