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
- 13147 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 handle decimal places while importing a flatfile into informatica?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
what is the difference between informatica6.1 and infomatica7.1
in reporting we add some new objects,how we get the count of the newly added objects to the report
can anyone suggest best free Talend data integration training online
What is the procedure for creating independent data marts from informatica 7.1?
Explain direct and indirect flat file loading (source file type) - informatica
How you prepared reports for OLAP?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is intricate mapping?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is the status code in stored procedure transformation?
What is repository manager?
How many types of sessions are there in informatica.please explain them?
What is the difference between router and filter?
