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