A product report has revenue under a blank category. How would you investigate it?

Instruction: Replace products with the actual business dimension. Explain your chosen treatment of late-arriving records rather than assuming all unmatched keys are bad transactions.

Context: Treats a blank bucket as a reconciliation problem, scopes the relationship behavior correctly, and preserves legitimate fact records.

Updated

Official answer available

Read the opening below, then unlock the full answer and practical guidance.

I'd check whether the sales rows have product keys that are missing from the Product dimension...

Upgrade to view official answer

Related Questions