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 / zak
Hi Babu,
Your logic works fine if you update the MVAR mapping
variable manually before you run the session. Is there a
way to update the MVAR within the mapping??
Thanks for your reply:)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the issues you have faced in your project? How did you overcome those issues?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Can we create a node as a gateway node and the same node can be assigned to a grid?
can we override a native sql query within informatica? Where do we do it?
How to update source definition?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is an active transformation?
What is the need for an etl tool?
What can we do to improve the performance of informatica aggregator transformation?
What is a stored procedure transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Explain constraint based loading in informatica
permutations of mapplet
What is the surrogate key?