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
While migrating the data from one environment to another environment how would you manage the connections?
What are the different types of olap? Give an example?
What is different between the data warehouse and data mart?
What is incremental aggregation?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Define filter transformation?
What are active and passive transformations?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is option by which we can run all the sessions in a batch simultaneously?
Can you generate sequence numbers without using the sequence generator transformation?
can we override a native sql query within informatica? Where do we do it?
What is data movement mode in Informatica and difference between them?
tell me 5 session failure in real time how can you solve that in your project?
Write the program through which the records can be updated?