However, there can ... primary key or when capturing granularity and hierarchy of the data is desired. Once you have decided on the primary key for your dimension table, you need to implement it ...