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
- 13783 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 the differences between source qualifier and joiner transformation?
Do you find any difficulty while working with flat files as source and target?
What are the components of the workflow manager?
What are the components of workflow manager?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Explain sessions?
What are the guidelines to be followed while using union transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
update strategy transformation in informatica
What are the new features of Power Center 5.0?
Explain the mapping variable usage example in informatica
Why filter transformation is an active one?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
