SQL Server Performance

Datawarehouse Design Question

Discussion in 'Analysis Services/Data Warehousing' started by JPGSQP, Apr 10, 2005.

  1. JPGSQP New Member

    Hello Folks

    Which is a better DW Design. Having a Fact Table with separate table for each Dimesion Table, which is joined to Fact Table with Numeric Keys. (This is what I want as all the articles, examples that I have been through, is based on this Design). But my Business User wants one large table with all Facts and Dimensions in there and then Build the Dimension from that when building the Cube?

    What are the pros and cons of each design type?

    We have about 20 Dimensions most of them Varchars ranging from 2 to 8 characters in length.

    Thanks
  2. satya Moderator

    http://www.databasejournal.com/features/mssql/article.php/10894_1466091_2 for relevancy.

    HTH

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page