Level: Introductory to Intermediate

Kevin Goff

Microsoft SQL Server MVP

Practice Manager

SetFocus, LLC

We'll take several of the key concepts in Data Warehousing and demonstrate some implementations using SQL Server Integration Services and Analysis Services.

You've read some of the well-known Data Warehousing books—now what? How do you take the structures and disciplines of books like the Ralph Kimball series and implement them? This session will take several of the key concepts in Data Warehousing and demonstrate some implementations using SQL Server Integration Services and Analysis Services. We'll look at items such as Type 2 Changing Dimensions, Confirmed Dimensions, Dimension Outriggers, Role-Playing Relationships, Many-to-Many Bridge table relationships, Factless Fact tables, Handling of NULL foreign key values, and more.

You will learn:

• Techniques for Populating Fact Tables and Dimension tables using T-SQL MERGE statements
• Special considerations for managing Type 2 Slowly Changing dimensions
• Tips for implementing many of the patterns found in the Kimball methodology