Back to Browse

Faster Data Loads with Change Data Capture

11.2K views
Sep 27, 2022
6:57

We left off the series talking about incremental loading, but if we are pulling data from a Microsoft SQL Server database, we can take advantage of the Change Data Capture (CDC) feature to make the data load faster. Chapters 00:00 Intro 01:11 Enable CDC in SQL 04:03 Review CDC in Panoply 04:34 Show Results 06:18 Recap Link to CDC instructions for SQL Server: https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/enable-and-disable-change-data-capture-sql-server?view=sql-server-ver16 #NPT #Panoply #DataWarehouse

Download

0 formats

No download links available.

Faster Data Loads with Change Data Capture | NatokHD