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.
- 7 Answers
- 13791 Views
- TCS, I also Faced
- E-Mail Answers
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
Define update strategy?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
wf dont have integration severances how you can run?
What is data movement mode in Informatica and difference between them?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is the scenario which compels informatica server to reject files?
How are the sources and targets definitions imported in informatica designer?
How would you copy the content of one repository to another repository?
How to load a Dimension ? and how to load a fact table?
How to join three sources using joiner? Explain though mapping flow.
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
what is the Default Source Option For Update Strategy Transformation?
Define the various join types of joiner transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is a router transformation?
