Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Dimension Table with Composite Key

2 posters

Go down

Dimension Table with Composite Key Empty Dimension Table with Composite Key

Post  hunain Sun Oct 27, 2013 4:02 am

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

Back to top Go down

Dimension Table with Composite Key Empty Re: Dimension Table with Composite Key

Post  ngalemmo Sun Oct 27, 2013 10:04 pm

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.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum