4th - 7th May 2016


Advanced Dimensional Modelling

This session is about advanced dimensional modelling topics such as Fact Table Primary Key, Vertical Fact Tables, Aggregate Fact Tables, SCD Type 6, Snapshotting Transaction Fact Tables, 1 or 2 Dimensions, Dealing with Currency Rates, When to Snowflake as well as other methods of managing dimensions. Prerequisites: You need have a basic knowledge of dimensional modelling and relational database design.
Presented by Vincent Rainardi at SQLBits VIII