Company has the following two statements need to be developed, report 1 and report 2
Now I can think of two kinds of establishing data warehouse solution
Solution a:
Scheme 2:
Want to ask everybody the teacher, if you are, will choose plan a or two? Or there is a better solution?
Scheme of a data warehouse high reusability, but the query time will increase
Scheme of the data warehouse low reusability, but the query time soon
Now very entanglements this problem
CodePudding user response:
Data warehouse layer with 2, data mart layer in one way,