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


Please Help Members By Posting Answers For Below Questions

What is union transformation?

575


server hot-ws270 is connect to Repository B. What does it mean?

1858


What is update strategy transform?

580


Could you explain what is enterprise data warehouse?

558


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1976






What are the main issues while working with flat files as source and as targets ?

657


How to do unit testing in informatica? How to load data in informatica ?

654


What are different types of transformations available in informatica?

588


What are the advantages of informatica?

576


what is diff b/t sorter t/r and agg have the option sorter property...

1748


my source is junk data how will u remove that junk data by using unix please any one replay me

3244


What is a stored procedure transformation?

611


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?

1320


What are the steps involved in the migration from older version to newer version of Informatica Server?

1587


What is an aggregator transformation?

617