Separate Columns for Measures or One Measure Column and Dimension Id

  • 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

  • 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[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply