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
What is union transformation?
server hot-ws270 is connect to Repository B. What does it mean?
What is update strategy transform?
Could you explain what is enterprise data warehouse?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are the main issues while working with flat files as source and as targets ?
How to do unit testing in informatica? How to load data in informatica ?
What are different types of transformations available in informatica?
What are the advantages of informatica?
what is diff b/t sorter t/r and agg have the option sorter property...
my source is junk data how will u remove that junk data by using unix please any one replay me
What is a stored procedure transformation?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is an aggregator transformation?