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
- 15240 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
without table how to come first record only in oracle?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How do you load only null records into target?
How identifying bottlenecks in various components of informatica and resolving them?
Explain your project of banking domian.
What is the benefit of partitioning a session?
What are mapplets? How is it different from a Reusable Transformation?
Explain the different dimensions.
How many types of sessions are there in informatica.please explain them?
Do you find any difficulty while working with flat files as source and target?
What is dimensional table?
What are the informatica performance improvement tips
How can you validate all mappings in the repository simultaneously?
what is SDLC way of code development?
Is it possible to revert a global repository to local one and why?
