Implementing a Data Warehouse with SQL Server: (02) Data Flow - Extract Data

Sign in to queue

Description

A key process in the development of a data warehouse is the extraction of data from your operational systems. In this module, you'll hear about the methods available to you and the advantages and disadvantages of each, as well as learning how to configure communication between data sources and data destinations.

  • [01:13] - Connection Managers
  • [12:06] - Data Sources and Data Destinations
  • [23:49] - Using Change Data Capture to Extract Information
  • [32:23] - Using Change Tracking to Extract Information

Full course outline:

Embed

Download

Download this episode

Download captions

The Discussion

Add Your 2 Cents