Why would you use a complex fact table instead of a simple fact table? Note: There are 3 correct answers to this question.
It supports structural dimensions.
It provides full support to calculate hires, movements, and terminations.
Source records can be reduced to one active fact record for any point in time.
Source table records can be spliced across time.
Tables can be sourced from a Lookup.
Submit