Create a mapping which contains 2 target tables. When the
session runs for the first time it shud load Target table 1
and when it runs for second time it shud load Target
table 2.
Answer Posted / perumal
Source -> sq -> sequence Generator -> exp trans -> router
trans -> tgt1/tgt2
create variable nxt_val with next value return from seq gen
and in router give rule as mod(nxt_val,2)<>0 to load tgt1
(since first run value will be 1) and mod(nxt_val,2)=0 to
load tgt2.
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Is it possible to revert a global repository to local one and why?
Make a note of the quantity vaults made in informatica?
Global and Local shortcuts. Advantages.
Write the prerequisite tasks to achieve the session partition?
How would you join a node to the already existing domain?
Differentiate between sessions and batches?
Where is metadata stored?
How can you differentiate between powercenter and power map?
Mention a few design and development best practices for informatica?
what is Active lock explain
What is the commit type if you have a transaction control transformation in the mapping?
What differs when we choose the sorted input for aggregator transformation?
Explain what transformation and how many are there in informatica?
What are the types of caches in lookup?
What is decode in static cache?