Level: Introductory to Intermediate
Microsoft SQL Server MVP
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. You'll examine 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