Faster Data Loads with Change Data Capture
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...
#NPT #Panoply #DataWarehouse