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
How might one distinguish in the case of mapping is right or not without associating session?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is the sequence generator transformation in informatica?
What are the measure objects?
Please let me know how to make encryption and decryption with example?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Explain what are the different types of transformation available in informatica.
Is it possible to create multiple domains on a single Informatica server?
What is source qualifier transformation in informatica?
What are the new features of informatica 9.x at the developer level?
Is stop and abort are same in informatica?
How to create Target definition for flat files?
What is decode in informatica?