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.
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