Change Data Capture (CDC) Made Easy with SSIS 2012

Share URL
Embed Code
Share by Email
Send to social websites
Report this video as inappropriate You can report this video if you think it to be inappropriate, we will review your submission soon. If your reason is not listed here, like copyright infringements, please contact us directly by email. Select your reason
Sexual Content Violent or Repulsive Content
Hateful or Abusive Content Harmful Dangerous Acts
Child Abuse Spam
Uploaded by Keith on 8/5/2015
One of the hidden gems introduced in SQL Server 2008 was change data capture. Loading your data warehouse has never been easier thanks to new components in SSIS 2012 designed specifically to consume CDC data. This amazing feature automates the process of detecting inserts, updates and deletes in your data; a vital step in determining type 1 and type 2 record updates. This session will begin by discussing the setup and configuration of CDC. Next Brad will jump into SQL Server Data Tools and walk you step by step through creating an SSIS package to load a dimension that will leverage all the new tasks and components. After this session you will have a very powerful tool in your SSIS tool belt.
Comment
Login to share your thoughts on this video, if you do not have an account please Register first.