SQL Server connector unterstützt SCD type 2
Der Microsoft SQL Server connector in Lakeflow Connect unterstützt nun SCD type 2 und kann damit eine Historie von Datenänderungen führen, statt veraltete Datensätze zu überschreiben.
The Microsoft SQL Server connector in Lakeflow Connect now supports SCD type 2. This setting, known as history tracking or slowly changing dimensions (SCD), determines how to handle changes in your data over time. With history tracking off (SCD type 1), outdated records are overwritten as they're updated and deleted in the source. With history tracking on (SCD type 2), the connector maintains a history of those changes. See Enable history tracking (SCD type 2).