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 / babu
Hi,
By using mapping variable,we can achieve this logic.
i.e SRC==>TRANS==>FLT1 ==>TRG1
|==>FLT2==>TRG2
in FLT1 place a condition mod(MVAR,2)=1,in FLT2 place a
condition as mod(MVAR,2)=0
MVAR is nothing but a mapping variable.
I think all are knows how to create,declare and call the
mapping variable.
please concern me if any doughts.
Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
What are the guidelines to be followed while using union transformation?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Why is sorter an active transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Explain informatica architecture - version 8 / 9
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Difference between Data and Index Caches?
What are the different lookup cache(s)?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
lookup transformation with screenshots
What is a repository? And how to add it in an informatica client?
What is a pre-defined event and user-defined event?
What are the differences between oltp and olap?
What are the reusable transformations?