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.
Slide Deck 270 KB , MP4 Video Low 56 MB , MP4 Video Med 82 MB , MP4 Video High 184 MB , MP4 Video HD 353 MB