Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 7 Answers
- 15010 Views
- TCS, I also Faced
- E-Mail Answers
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
How can we delete duplicate rows from flat files?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How to update a particular record in target with out running whole workflow?
Mention few power centre client applications with their basic purpose?
Explain constraint based loading in informatica
Performance tuning( what you did in performance tuning)
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Explain in detail about scd type 1 through mapping.
What is complex mapping?
Explain the shared cache and re-cache?
What are the differences between a connected lookup and unconnected lookup?
What is joiner change?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What do you mean by channel change?
What are the different lookup cache(s)?
