Place descriptive status attributes where they preserve history and reuse without bloating facts.
You are modeling an order fact. Stakeholders want to filter orders by customer lifecycle status and also analyze what the status was when each order occurred. Where should status live?
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in