Dimensional modeling (part 2)

22 Março 2022, 13:00 • António Ferreira

Dimensional modeling (part 2): retail sales example; primary keys and degenerate dimensions; date dimension; hierarchies in dimensions; surrogate keys in dimensions; snowflaking; analysis of dimensional models; additive, non-additive, and semi-additive measures; factless fact tables.