Will the table get locked in first session and the other will wait till the former releases the lock?Will records be inserted from both sessions simultaneously? If so, how many such parallel inserting sessions can be run simultaneously?

Question

What happens if we try to insert into the same table in multiple transformations at the same time?

+8

Will the table get locked in first session and the other will wait till the former releases the lock?
Will records be inserted from both sessions simultaneously? If so, how many such parallel inserting sessions can be run simultaneously?

Hi Harish,

thank you for reaching out.

Please be informed that two data jobs joining the same table at the same time will cause one of the transformations to fail.

Best Regards,

Blenda