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 is Active lock explain
What does “tail –f” command do and what is its use as an Informatica admin.
Enlist some properties of sessions.
How to join three sources using joiner?
in reporting we add some new objects,how we get the count of the newly added objects to the report
How can we use mapping variables in informatica? Where do we use them?
What is complex mapping?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What are the popular informatica products?
How can you increase the performance in joiner transformation?
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.
What is depict expression change?
How many number of sessions can one group in batches?
waht type of interface is used for testing the data in informatica
How can informatica be used for an organization?