Level: Introductory to Intermediate
Kevin Goff
Microsoft SQL Server MVP
Practice Manager
SetFocus, LLC
This session will 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 content of well-known Data Warehousing books: now what? How do you take the structures and disciplines inside such books as 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:
- Some of the most critical "DOs and DON'Ts" in the design and population of fact and dimension tables
- ETL patterns for populating some of the more advanced dimension modeling concepts (such as type-2 changing dimensions)