Working on my first data warehouse project and learning online on the way using tutorials, articles, youtube videos etc.
I'm using data meant to mimic an OLTP database for a dvd rental company, and I'm at the stage of implementing my dimension and fact tables.
The fact table I'm currently building out is an inventory table - I want it to be a snapshot every month of a dvd's stock, including how many dvd were lost that month, and some other aggregates.
One thing I can't wrap my head around though is how to implement a date dimension - currently none of my other attributes capture a timestamp that can facilitate this.
and tutorials online don't really go into the details of how to build a snapshot fact table so that i can define the grain as 'week', 'month' etc.
I don't understand how my fact table can make a reference to a date dimension if my other dimensions don't contain a date attribute?
I'm attaching a photo of my model below in case it helps paint a better picture.