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
- 14975 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 is informatica metadata and where is it stored?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is the benefit of session partitioning?
explain abt ur project architecture?
How many numbers of sessions can one group in batches?
What happens when a session fails and you click on recover?
Where is metadata stored?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Explain why we use partitioning the session in informatica?
How does the aggregator transformation handle null values?
Under what condition selecting sorted input in aggregator may fail the session?
expain about the tune parameters?
How do you handle two sessions in Informatica
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Is it possible to use a client with different version than that of its Informatica server?
