Dimensional Modeling - Declaring Dimensions

Download a free trial of our On-Demand Training Platform: pragmaticworks.com/Training/On...
Presented by Mitchell Pearson
Identifying and modeling dimensions is a critical step in dimension design. In this webinar, we are going to walk through an overview of dimension table architecture and dimension modeling techniques.

[@jamesjaneway2115]

Best Type 2 illustrative examples I've seen. Well done!

[@terryliu3635]

This is really good, thank you!

[@ellenzhao7228]

Great video! Learnt lots from you.

[@PragmaticWorks]

Thanks! We are glad to hear it!

[@ranjithpals]

Great job!!

[@ThabangSerumola]

Thank you

[@judepieries1828]

This was great, it helped me get my head around some of the concepts.
QQ : why didn't promotion_sk make its way to the fact_sales. I understand the need for the bridge table and its benefit but don't we need the promotion_sk in the fact_sales to identify the products sold during a promotion.
Does it make sense to create a SK in the fact_promotions and add that sk in the fact_sales table ?

[@coding3438]

same question

[@maryk0505]

At around minute 34-35 you spoke of mini dimensions and then proceeded to demonstrate what I thought was a junk dimension. I understood from you earlier than a mini-dimension could be something like a price change of a product and NOT necessarily a Cartesian junk dimension. Is a junk dimension a type of mini dimension, and if so, is it also true that all mini dimensions are not necessarily junk dimensions?

[@kshitijpathak8646]

won't number of children, cars and bikes be in fact table as they seem like a measure columns?