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 / babu
Hi Zak,
By default the value of MVAR is 0.The value is
increment by at run time only.
i.e is SETVARIABLE($$MVAR,($$MVAR+1))
Let me know if u have any doughts
mail:
dwarak.vbr@gmail.com
+91-8861145051
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What do you mean by blocking transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is session task and command task?
What is a joiner transformation?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is option by which we can run all the sessions in a batch simultaneously?
What are junk dimensions?
What is the difference between writing a joiner query in ANSI style and THETA style?
How to do unit testing in informatica? How to load data in informatica ?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What are the new features of Power Center 5.0?
What is the function of aggregator transformation?
What are roles and groups and benefits of using them?
What does reusable transformation mean?
What is the format of informatica objects in a repository?