Advanced Integration Services

This course teaches how to work with Integration Services packages in the context of a data warehouse development project to perform extract, transform, and load operations.
Course info
Rating
(400)
Level
Advanced
Updated
August 14, 2013
Duration
3h 39m
Table of contents
Description
Course info
Rating
(400)
Level
Advanced
Updated
August 14, 2013
Duration
3h 39m
Description

This course explains how to apply Integration Services features to build packages that support the extract, transform, and load operations of a data warehouse. It covers design patterns for staging data and for loading data into fact and dimension tables. In addition, this course describes how to enhance ETL packages with data cleansing techniques and offers insight into the buffer architecture of the data flow engine to hep package developers get the best performance from packages. This course was written for SQL Server 2012 Integration Services, but most principles apply to SQL Server 2005 and later.

About the author
About the author

Stacia Misner Varga is a consultant, instructor, author, mentor, BI Partner for SQLSkills, and principal of Data Inspirations specializing in Microsoft business intelligence technologies for over 10 years. She is a frequent speaker at the PASS Summit, IT/Dev Connections conferences, and various SQL Saturday and Microsoft-related events worldwide.

More from the author
Getting Started with Power BI
Beginner
3h 14m
23 Jun 2016
Building Blocks of Biml
Beginner
4h 10m
29 Dec 2015
More courses by Stacia Misner Varga