Interested to Buy Any Domain ? << Click Here >> for more details...
I have one source table and three target tables.
When the session runs for the first time involving the
mapping,i want that the loading should take place in 1st
Target table only.
The 2nd time the same session runs the loading should take
place in 2nd Target only only
and similarly when the session runs for the 3rd time loading
should take place in Third only.
And again when the session runs for the 4th time loading
should take place in 1st Target table.
- 4 Answers
- 13122 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / harish konda
We can achieve this by using Mapping Variable and Mod function.
Create a mapping var. and using the SetVariable() fun increment its value by 1 every time when the session runs succesfully.
And in the Router create 3 groups and give the conditions, Mod($$var,3)=0,Mod($$var,3)=1,Mod($$var,3)=2.
And map each group of Router to 3 different Targets.
| Is This Answer Correct ? | 18 Yes | 2 No |
Post New Answer View All Answers
How do you handle two sessions in Informatica
What is the difference between STOP and ABORT options in Workflow Monitor?
where to store informatica rejected data? How to extract the informatica rejected data?
Reusable transformation and shortcut differences
How can you generate reports in informatica?
What are data-driven sessions?
What all are steps in up gradation of Informatica server?
What is an aggregator transformation?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
State the differences between sql override and lookup override?
Why update strategy and union transformations are active? Explain with examples.
Enlist the advantages of informatica.
How to generate sequence numbers without using the sequence generator transformation?
Difference between Data and Index Caches?
How many ways are there to do 'remove duplicate records in informatica'?
