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
- 12141 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 to load a Dimension ? and how to load a fact table?
How to do the error handling of if ur source is flatfiles?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Briefly define a session task?
How can we use batches?
what is size of u r database?
in reporting we add some new objects,how we get the count of the newly added objects to the report
How can we create index after completion of load process?
What is a joiner transformation and why it is an active one?
which one is better performance wise joiner or look up
What are mapplets? How is it different from a Reusable Transformation?
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
In warehouses how many schemas are there?
How can we handle two sessions in informatica?
What are the databases that informatica can connect to windows?
