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
- 11835 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
What is dimensional table?
How are the sources and targets definitions imported in informatica designer?
What is data transformation manager process?
What are the differences between source qualifier and joiner transformation?
What is meant by target load plan?
State the differences between sql override and lookup override?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How to create or import flat file definition in to the warehouse designer?
In informatics server which files are created during the session rums?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How to differentiate between the active and passive transformations?
What is a repository? And how to add it in an informatica client?
How to start a workflow using pmcmd command?
expain about the tune parameters?
Explain sessions. Explain how batches are used to combine executions?
