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 / subhajit
Alternative to mapping variable:
Use sequence generator, mod on that and then finally router.
Thanks
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What differs when we choose the sorted input for aggregator transformation?
What are Dimensional table?
How can we use mapping variables in informatica?
Is it possible to define a single node as a Gateway node as well as worker node?
How to differentiate between the active and passive transformations?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Design time, run time. If you don't create parameter what will happen
What is the use of transformation?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How to configure mapping in informatica?
Explain joiner transformation in informatica
Why sorter is an active transformation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How do you handle two sessions in Informatica