Hi Babu, Your logic works fine if you update the MVAR mapping variable

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.

Question Posted / zak

7 Answers
14982 Views
TCS, I also Faced
E-Mail Answers

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 dimensional table? Explain the different dimensions.

1168

What do you mean by filter transformation?

947

What do you mean by blocking transformation?

1030

What is target load order?

1234

What are ETL Tools?

1110

What is rank transform?

991

What are the reusable transformations?

1154

Explain how to import oracle sequence into informatica?

1005

What is the status code in stored procedure transformation?

1180

What's the layout of parameter file (what does a parameter file contain?)?

2381

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1102

Whats there in global repository

1689

what is the size of u r source(like file or table)?

2265

What is powercenter on grid?

1175

Why sorter is an active transformation?

1185