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?

Interview Candidate
Mar 24th, 2017
6
7519

DataStage

Answer

Showing Answers 1 - 6 of 6 Answers

sri

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