Place each data quality rule into the dimension it primarily protects. Completeness Validity Uniqueness Referential integrity Every active account has a non-null customer_id Subscription status is one of active, trialing, paused, canceled There is exactly one current health row per account_id Every order.account_id exists in the account dimension Every invoice has an issued_at timestamp before it enters revenue Net margin percentage stays between -100 and 100 Each billing_period has one subscription row per subscription_id Every support ticket has a matching customer record
Read the full lesson
Sign up free: one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in