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
- 13291 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 meant by LDAP users?
How to implement security measures using repository manager?
permutations of mapplet
How would you copy the content of one repository to another repository?
How to extract sap data using informatica? What is abap? What are idocs?
COM components can be used in Informatica
What is the need of an ETL tool?
How to configure mapping in informatica?
Performance tuning( what you did in performance tuning)
How would you join a node to the already existing domain?
Describe the impact of several join conditions and join order in a joiner transformation?
pmscmd startworkflow -sv
How you know when to use a static cache and dynamic cache in lookup transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is data movement mode in Informatica and difference between them?
