Modelling Tip- Why it makes sense to ALWAYS have a surrogate key for Date Dim?

While there is normally a consensus about using a surrogate key in all the dimensions in a dimensional model , there are some who wonder if we should be using a surrogate key for a date dimension. Date dimension is used in every single data model so this question is quite typical. Here are some… Continue reading Modelling Tip- Why it makes sense to ALWAYS have a surrogate key for Date Dim?

Template for Physical Dimensional Model Document

Dimensional Model as designed with the facts & dimensions using normally Ralph Kimball methods or sometimes using Bill-Inmon books , normally pertains to the so called "Logical Data Model" or "Logical Dimensional Model" . There are many steps which need to be done to execute this logical model into the physical model & in most… Continue reading Template for Physical Dimensional Model Document

Modelling Tip- How Junk Dimensions helps in DW Performance?

We have seen the concept of Junk Dimension in the preceding article and how it is developed and how it is helpful in the life-cycle of dimensional modelling. Some people however have the concern about the performance of Junk Dimension namely that since we are putting together multiple entities , that will affect the performance… Continue reading Modelling Tip- How Junk Dimensions helps in DW Performance?

Modelling Tip- Why one should always have A Junk Dimension in dimesnional model?

This article will try to explain what is junk dimension (also known as Mystery Dimension per Ralph Kimball new books) concept in the realm of dimensional modelling and why it is crucial to have at least one such junk dimension in every BI model. -Concept of Junk Dimension Junk Dimension simply put is the is… Continue reading Modelling Tip- Why one should always have A Junk Dimension in dimesnional model?