Modelling the Date Dimension in Data Vault

In our ongoing series, our CEO Michael Olschimke discusses a question from the audience:

"In many data sources we get data with a DATE data type. In some cases we want to use a Time-Dimension for this fields.

How would you model this in Data Vault:
As Time-Hub in Raw Vault and referencing that Hub in a Link?
As Time-Reference Table and then joining that in the IM? Should the Time Dimension hold a Hash Key as Dimension Key for that, or the Business Key (date)?
Or both options?"

Michael talks about Modelling the Date Dimension

Join the next live session: sfr.ee/friday
Ask questions via sfr.ee/dvfriday

Learn about Scalefree:
www.scalefree.com/
Learn about Data Vault:
scalefree.com/blog
LinkedIn:
sfr.ee/vdviLh
Twitter:
twitter.com/ScalefreeCOM
Call us: +49 (511) 879 89342

#DataDimension #DataModeling #DataModelling #TimeDimension #DataType #TimeHub #TimeReference #DataVault #Scalefree #DataWarehousing #DWH #EDW #BusinessIntelligence #BI #Data