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
- 13312 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
Explain how to import oracle sequence into informatica?
What are the differences between joiner transformation and source qualifier transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is meant by query override?
What is the difference between informatics 7x and 8x and what is latest version?
Can we create a Integration service without a Repository service and vice versa?
What are the different clients of powercenter?
What is resilience time?
What are pre and post-session shell commands?
How are indexes created after completing the load process?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is rank index in rank transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?
hi real timers . iam waiting for ur reply regarding ETL TESTING
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
