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
- 12459 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
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are the main features of Oracle 8i with context to datawarehouse?
what are 3 tech challenges/ common issues you face?
What are the differences between oltp and olap?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Define Pmrep command?
generate date / time dimension in informatica
Where do we use mapping variables in informatica?
Explain what are the different types of transformation available in informatica.
What is resilience time?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
whats the logic to load the lower level of granularity of data to fact table.
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
In informatica workflow manager, how many repositories can be created?
