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
Where is metadata stored?
How do you load only null records into target?
What is complex mapping?
Explain pushdown optimization $pushdownconfig parameter - informatica
How to load the data from people soft hrm to people soft erm using informatica?
Design a mapping to load a target table with the following values from the above source?
What the difference is between a database, a data warehouse and a data mart?
Quickly characterize reusable change?
What are the components of the workflow manager?
What are pre and post-session shell commands?
What is a code page?
How you can differentiate between connected lookup and unconnected lookup?
If informatica has its scheduler why using third party scheduler?
what is diff b/t sorter t/r and agg have the option sorter property...
Repository user profiles