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: [ Ссылка ]

#NPT #Panoply #DataWarehouse

свернуть