DSXchange

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.

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.