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.
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
Why is sorter an active transformation?
what is size of u r database?
How an expression transformation differs from aggregator transformation?
What is status code in informatica?
What is rank index in rank transformation?
Reusable transformation and shortcut differences
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is update strategy transform?
What are the advantages of using informatica as an etl tool over teradata?
What is rank transformation?
What are the advantages of informatica?
What is the meaning of decode in informatica?
What are the different transaction levels available in transaction control transformation?
Which are the different editions of informatica powercenter that are available?
Briefly define a session task?