Model Multi - Fact

Marco1
New Member

Hello all, I'm a newbie. I need to realize a model that link together two or more fact tables.

For example Movements and Orders.

Both the facts have in common the SKU Dimension, and each have one or more specific dimensions:

MOVEMENTS_TBL
MOV_ID
MOV_DATE
MOV_REASON_COD
SKU_COD
MOV_QTY
ORDERS_TBL
ORD_ID
ORD_DATE
ORD_REASON_COD
SKU_COD
ORD_QTY
SKU_TBL
SKU_COD
SKU_DESCR
BRAND_COD
BRAND_DES

What are the best way to proceed?

Thanks a lot.

0 6 1,098
6 REPLIES 6
Top Labels in this Space
Top Solution Authors