Home Forums Data Warehousing Analysis Services How to Define a schema for the fact table, and the dimensional tables in SQL from a relational schema? RE: How to Define a schema for the fact table, and the dimensional tables in SQL from a relational schema?

  • July 30, 2013 at 2:00 am

    #1636865

    phamkhanhtung1989 (7/30/2013)

    that is what I am asking for. to create the database, can I use the normal way as relational database? and which table do I have to create first, dimensional tables or fact table?

    A data warehouse in SQL Server is just the same as a regulare database, it is just modelled using the dimensional methodology.

    An OLAP database however, is created using SSAS.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP