A presentation by DWS Consultant Ross Leishman based on the Kimball Group's 4-Day course: ETL Architecture In-Depth.
Chapters and TimeStamps:
1. 00:00 Intro
2. 05:37 Hybrid Slowly Changing Dimensions
3. 15:07 Mini Dimensions
4. 28:03 Junk Dimensions
5. 33:35 Bridge Tables
6. 41:29 Ragged Hierarchies
7. 51:38 Coverage Facts
8. 55:10 Summary and Questions
This is the 2nd of a 3-part Series.
Part 1: Dimensional Modelling 101 - • ETL Architecture In-De...
Part 2: Advanced Dimensional Modelling - • ETL Architecture In-De...
See Also "the Data Warehouse Toolkit - The Complete Guide to Dimensional Modelling (2nd Edition) - R. Kimball, M.Ross.
DWS Ltd is an Australian IT Company www.dws.com.au
4 окт 2024