Over time, certain designs have emerged in SSIS as the best way to solve particular types of problems. These have become best practices, and can be used in your environment as well. In this course, you will learn about the most common patterns used in data warehousing, which are also applicable to non-data warehouse situations.
Author Name: Robert Cain
Author Description:
Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is a course author for Pluralsight, team member at Linchpin People, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQL Saturdays. Robert has over 25 years’ experience in the IT industry, working in a variety of fields including manufacturing, insurance, teleco… more

Table of Contents

• Introduction and Setup
  18mins
• Basic Design Patterns Part 1
  46mins
• Basic Design Patterns Part 2
  25mins
• Advanced Design Patterns Part 1
  25mins
• Advanced Design Patterns Part 2
  24mins
• Fact Pattern, Master/Child Patterns
  30mins