In data warehousing scenarios, it's common to create a consolidated presentation layer table from multiple source tables. When dealing with slowly changing dimensions (SCD), especially SCD Type 2, it becomes essential to maintain historical changes accurately.

This session introduces the concept of driving and referential tables and then proposes a solution to handle updates for such entities. It also explores the exceptional cases where updates occur in both driving and referential tables for a certain natural key.