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
On this page of the site you can watch the video online Faster Data Loads with Change Data Capture with a duration of hours minute second in good quality, which was uploaded by the user Nathan Patrick Taylor 27 September 2022, share the link with friends and acquaintances, this video has already been watched 11,194 times on youtube and it was liked by 33 viewers. Enjoy your viewing!
