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


Please Help Members By Posting Answers For Below Questions

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

1864


Mention few power centre client applications with their basic purpose?

528


What is dimensional table?

617


How can we use batches?

598


What the difference is between a database, a data warehouse and a data mart?

588






What is olap (on-line analytical processing?

635


What are the differences between source qualifier and joiner transformation?

589


What is a code page?

704


What could be the possible resons of locks by user?

657


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

600


Separate from a database, an information bazaar, and an information stockroom?

601


Under which circumstances, informatica server creates reject files?

589


What is intricate mapping?

586


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

9157


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1584