Things you Should Avoid when Designing a Data Warehouse

We always look at the practices that we follow during the data warehouse design. However, we don't look at what are the things we should avoid during the data warehouse design. This article is looking at those points. 

We looked at a few of the data warehouse concepts before in Microsoft Technologies. First of all, you need to look at the infrastructure planning for a data warehouse. During the data warehouse design, it is important to include surrogate keys to dimension tables. Date dimensions is a special dimension that is used in data warehouse modelling. Historical data is an important aspect in a data warehouse that is used in Slowly Changing Dimensions (SCD).