Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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, November 3, 2015 8:41 AM
Points: 249, Visits: 482
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


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, February 17, 2016 11:43 AM
Points: 604, Visits: 959
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