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
- 15039 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
What are session parameters ? How do you set them?
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
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How can a transformation be made reusable?
What is native users?
Tell me about MD5 functions in informatica
Can you generate sequence numbers without using the sequence generator transformation?
Can you use flat files in Mapplets.
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What do think which one is the better joiner or look up?
Explain why we use partitioning the session in informatica?
How to Create a folder using pmrep command?
What is a sequence generator transformation?
how to load rows into fact table in data warehouse
can we override a native sql query within informatica? Where do we do it? How do we do it?
