Create and populate Time Dimension
Case We have sensors in our building that output data every minute which we want to use in a dimensional model. Therefore we need a Time Dimension to…
Search Suggest
DIMENSION
DIMENSION
Insert unknown dimension record for all dimension tables
Case I have a lot of dimension packages in SSIS that all insert a default record for unknown dimension values. It's a lot of repetitive and borin…
Create and fill Age dimension
Case Is there an easy way to create and populate an age dimension with age groups? Solution Creating an age dimension is usually done once and probab…