2 Replies Latest reply: Aug 28, 2014 1:45 AM by 2605470 RSS

    transaction control in ODI is leading to locks on temporary tables

    2605470


      Hi All,

       

      I have a requirement where in i need to ensure that automatic rollback happens when any step fails in the package.

      I have a list of interfaces which loads couple of tables which are linked by foriegn keys.

      so for this case i have set all the DML steps in  IKM oracle incremental update km to transaction1

      Did the same in CKM too.

      Now a lock is happing on all I$ and E$ tables when trying to create a index on these tables.

      The uncommited DML statements executed before this index creation step is the reason for this. Is there a way to perform transaction control without these locks happening in ODI. Please share any inputs on the same.

       

      Thanks in advance