Ten opinions of data warehouse modeling
1) The problem must be answered;
2) There must be a correct fact table;
3) There will be the correct dimensional table, describing the business term must be expressed in the end user;
4) It is necessary to understand the company's process affected by the data warehouse or the company's process affecting the data warehouse;
5) For the fact table, it should have the correct "granularity";
6) Store corporate historical data in accordance with you need to store;
7) Integrate all the necessary data in a meaningful way of the company;
8) Create the necessary summary table;
9) Create the necessary index;
10) The data warehouse database can be loaded and available in a suitable way.
