Creating Transactions in ODI
715308Apr 5 2011 — edited Apr 11 2011Hi All,
I have a ODI procedure which has source and target as Oracle Databases . There are 3 steps.
Both step1 and step2 selects data from a source database and inserts into a separate target database. Both step 1 and step 2 should complete but should not commit.
step 3 has an explicit commit statement.
So summarzing , step 1 , 2 , 3 should be used in a single transaction. Till now i have completed step 1 and step 2. I tried to use No Commit feature and set the transaction to Transaction 0. But still each steps are committing explicitly and data is getting inserted without the third step(commit step). The jdbc driver used fror the same is ojdbc14.jar.
Can anyone please help in this regard. I have referred to previous posts but that did not solve the problem.
Thanks,
AC