Wednesday, May 1, 2013

[SQL Server Data Warehousing] Data warehouse


We have constructed the data warehouse  in SQL Server -> creating dimensions, fact tables. Its not relational database(have not added primary key or surrogate key) in the data warehouse.


Our functional area is Terminal & Ports, so is this right approach to have the non relation database or not?


Should we go with Normalization approach or dimensional?



.

social.technet.microsoft.com/Forums

No comments:

Post a Comment

Search This Blog