In one of my business scenario , i have to do transaction of data to two tables simultaneous.(one is update and other is insert) transaction of records to both tables have to happen simultaneously, since even during the fail over of the job, for all the inserted records to one table, update-ion of other table has to be in sync.I tried to use Pl/sql block using Stored procedure stage by passing input records as a parameter but the records are processing dead slow since the pl/sql code is invoked for each row. Please suggest me a way to implement this scenario effectively .
Use a connector with two input links and combine the two inputs into a single transaction within the stage. This can also be done with the older ODBC stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.