admin管理员组

文章数量:1353252

This question is regarding Dimensional Data Modeling. Business Req: When customer ordered 10 items (Order-1), 5 items are available in in 1 fulfillment center, 3 items in 1 Fulfillment center, and last 2 items are available in another fulfillment center. In this case Order-1 split into 3 different orders (3 sub orders).

my current design: OrderFact, and OrderSplitFact. Shipment_Fact is connected to both OrderFact or OrderSplitFact. we have CustomerDim, DateDim, ProductDim

Note: all my Dims are SCD Type-2, and Facts are Append/Insert only

Question:

  1. in this scenario all facts are directly connected. can we do?

本文标签： dimensionsDimensional Data modelingStack Overflow

版权声明：本文标题：dimensions - Dimensional Data modeling - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1743887694a2556359.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。