Link Order Functionality ?

kaps · Post by **kaps** » Fri May 04, 2012 10:02 am

Can we have a job with 4 different database stages (API or DB2 connector) from transformer and we will be updating same table in all the 4 stages. As this may cause table locks, I thought If I order the links one by one that would take care of the lock issue but one incoming record may send data to more than one database links. How does the link order work in this case ? Does it buffer the data for second dDB stage when the update of 1st DB stage happens ?

Please advise.

qt_ky · Post by **qt_ky** » Fri May 04, 2012 6:20 pm

See if one stage can handle it and try setting it to update 1 row at a time with the stage settings do you don't deadlock/timeout yourself.