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
generate date / time dimension in informatica
COM components can be used in Informatica
What is deployment group?
what are the Methods For Creating Reusable Transformations?
What is the session task and command task?
Explain what transformation and how many are there in informatica?
list out all the transformations which use cache?
Why update strategy and union transformations are active? Explain with examples.
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What do think which one is the better joiner or look up?
How to join three sources using joiner? Explain though mapping flow.
What is the command used to run a batch?
What does command task mean?
Sequence generator, when you move from develoment to production how will you reset
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?