Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Separate Columns for Measures or One Measure Column and Dimension Id Expand / Collapse
Author
Message
Posted Friday, August 1, 2014 10:16 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 7:47 AM
Points: 248, Visits: 476
Which Dimensional Model is better for performance and scalability?

Option 1:

MyFactTable:
Id (PK),
DateFK,
CustomerFK,
ProductFK,
FirstAttemptCount,
SecondAttemptCount,
ThirdAttemptCount


Option 2:

MyFactTable:
Id (PK),
DateFK,
CustomerFK,
ProductFK,
AttemptTypeFK,
AttemptCount


AttemptTypeDimension:
AttemptTypeId,
AttemptTypeName



Option 3:

FirstAttemptFactTable:
Id (PK),
DateFK,
CustomerFK,
ProductFK,
FirstAttemptCount


SecondAttemptFactTable:
Id (PK),
DateFK,
CustomerFK,
ProductFK,
SecondAttemptCount


ThirdAttemptFactTable:
Id (PK),
DateFK,
CustomerFK,
ProductFK,
ThirdAttemptCount
Post #1598756
Posted Friday, August 1, 2014 10:21 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, October 23, 2014 11:21 AM
Points: 593, Visits: 929
Please only post a question in a single forum. Here is a link to the active one: http://www.sqlservercentral.com/Forums/Topic1598758-147-1.aspx



Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1598760
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse