SCD Insert, Update and Link Data

While implementing SCD, there are two output links updating data to same table. One link for insert and one link for update. How it is possible? Will it not result a write lock on a table if two links accessing same table for writing?

Showing Answers 1 - 2 of 2 Answers


  • Mar 27th, 2017

Table level lock applies only when we explicitly define during table creation. In the case you mentioned to update and insert, there will be row level lock implies on that table.
Logically, Insert records are new and updated records are already existing in the table. so , row-level lock will lock those updated records and there will be no issue to New/Insert records.

Correct me if I am wrong so that I can improve my knowledge


  • Mar 30th, 2017

Thanks for the answer

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions