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