Dimension Table with Composite Key
2 posters
Page 1 of 1
Dimension Table with Composite Key
I have a section table in my ERP. It contains sections for the courses offered. The columns part of composite key are term code and section. My question is should this be modelled as fact or dimension. if its dimension do i create something as section_key(surrogate) which will uniquely identify a section based on the natural key term code and section. Please also note that section is unique within a term so the same section can be used in another term. please advise. thanks.
hunain- Posts : 19
Join date : 2013-09-15
Re: Dimension Table with Composite Key
Yes, as a dimension the natural key would be term and section, it would resolve to a unique primary surrogate key. Such an arrangement is very common. As a dimension you would store attributes such as room, capacity, time, etc. The enrollment would be a fact that contains a FK to the dimension.
Similar topics
» Composite Dimension Natural Keys - Attribute Used In Multiple Dimensions as well as Fact Tables
» Pros and cons of consolidated dimension table Vs. many dimension table ?
» Can a dimension table directly link to another dimension table?
» joining dimension table to dimension and again fact table
» Pros and cons of consolidated dimension table Vs. many dimension table ?
» Can a dimension table directly link to another dimension table?
» joining dimension table to dimension and again fact table
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum