Tuesday, March 19, 2013

Why have more than one fact table instead of a single fact table?

We cannot combine all of the business processes into a single fact table because:
  1. The separate fact tables in the value chain do not share all the dimensions. You simply can’t put the customer ship to dimension on the finished goods inventory data.
  2. Each fact table possesses different facts, and the fact table records are recorded at different time along the value chain.

No comments:

Post a Comment