BI Dimensional Modeling, Data Mart Design 问题 求教

sfy9

求教一个问题，做BI的人士请指点：

假定同一个DB server上有五个Data Mart （which contain data required for specific departments），每个都用到DimProduct，是把DimProduct存上5份么？
The scenario is
DM1 : DimProduct, Dim1, FactTable1
DM2:  DimProduct, Dim2, FactTable2
DM3 : DimProduct, Dima, FactTable3
DM4:  DimProduct, Dimb, FactTable4
DM5:  DimProduct, Dimc, FactTable5

存上5份的益处是便利建FK，放慢数据查问。 但害处是占用存储空间，并且万一5份之间有inconsistent怎么办哪？

qq1002513

Dim_product_view1,2,3,4,5

yelhao

不论你怎么设计
周日晚上9点还在任务
老板要加你人工了

bald

you cannot build a foreign key between a FactTable and a DimProductView.

Have u thought about this?

血刃

整个做成view

fenjin1970

foreign key only maintains data integrity but does not improve performance. As data integrity can be maintained in the ETL, you do not need a foreign key between a FactTable and a DimProductView.