Please continue making more videos. I love the way you explain complex topics..
An example with a surrogate key will be helpful, as it will be unique and serve as the primary key. This is essential for tracking history in SCD Type 2, since we cannot set the natural ID (like customer_id) as the primary key.
Amazing Video (y). Get going!
Great video
Well explained thanks
Very helpful video!!
excellent
Good Job!
saving marital status whether scd type 3 would work?
in type2 SCD the surrogate key should also change for new record.In the video it still shows key as 123 for all three records.Surrogate Key is Primary key hence there cannot be duplicates
In SCD6 current office and history office is given. Then why not current salary and historical salary is mentioned. Is that intentional?
Thank you so much 😊
If the ID col is primary key, then how do we add additional rows?
@TechCoach