Accumulating Snapshot Fact Table
One row per order, updated as it is picked, shipped, and delivered. An accumulating snapshot makes lead times a subtraction, but keeps one date per step.
One row per order, updated as it is picked, shipped, and delivered. An accumulating snapshot makes lead times a subtraction, but keeps one date per step.