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 is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Mention few power centre client applications with their basic purpose?
What is dimensional table?
How can we use batches?
What the difference is between a database, a data warehouse and a data mart?
What is olap (on-line analytical processing?
What are the differences between source qualifier and joiner transformation?
What is a code page?
What could be the possible resons of locks by user?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Separate from a database, an information bazaar, and an information stockroom?
Under which circumstances, informatica server creates reject files?
What is intricate mapping?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance