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 target load order?
To import the flat file definition into the designer where should the flat file be placed?
Is it possible to create multiple domains on a single Informatica server?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How to do the error handling of if ur source is flatfiles?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are junk dimensions?
How do you remove duplicate records in informatica? And how many ways are there to do it?
How are the sources and targets definitions imported in informatica designer?
What are the limitations of joiner transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Design time, run time. If you don't create parameter what will happen
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
In development project what is the process to follow for an etl developer from day1
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?