- Course
Implement Incremental Loads and Change Data Capture in SQL Server Data Warehouses
The process of getting data from a transactional system to a data warehouse is not simple. This course will teach you various ways of identifying changed data and loading those changes without unnecessary impact on source or destination.
- Course
Implement Incremental Loads and Change Data Capture in SQL Server Data Warehouses
The process of getting data from a transactional system to a data warehouse is not simple. This course will teach you various ways of identifying changed data and loading those changes without unnecessary impact on source or destination.
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
In modern business intelligence applications, out of date data is useless data. Correctly and optimally loading changes into a data warehouse is essential to the success of any BI project. In this course, Implement Incremental Loads and Change Data Capture in SQL Server Data Warehouses, you’ll gain the ability to implement such a loading strategy. First, you’ll explore multiple ways to identify changed data. Next, you’ll discover optimal ways to load that into the destination. Finally, you’ll learn how to monitor, audit, and re-run load jobs without causing more problems. When you’re finished with this course, you’ll have the skills and knowledge of data warehouse loading needed to succeed in any data warehouse project.