Ok. I will need to create another inventory fact table. Inventory fact table will consist of date key, inventory key (degenerate dimension key), product key, warehouse key and quantity on...

• This reply was modified 4 years, 10 months ago by  TestKing2017.

Thank you for your suggestion. I have another point which is better between using the product dimension table for the quantity on hand and create another inventory dimension for storing...

If I would like the warehouse_fact to monitor the quantity of products left after each day, how should I organize it? I think of including the warehouse_id into the shipment_fact...

Ok..The order table is to record the number of products order by each customer so I deem as a transaction.... Also for the warehouse table, I would like to find...