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
Where are the source flat files kept before running the session?
What is a passive transformation?
What do you mean by blocking transformation?
How can you differentiate between powercenter and power map?
What is the different lookup cache(s)?
Performance tuning( what you did in performance tuning)
What is a snowflake schema?
How do we call shell scripts from informatica?
How to delete duplicate row using informatica?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
In development project what is the process to follow for an etl developer from day1
Performance tuning in UNIX for informatica mappings?
how tokens will generate?
What is incremental aggregation?
How can we use batches?