Decision Walk: Reuse Dimensions Across Sales and Returns
Choose how to reuse date, customer, and product dimensions across separate business-process facts.
The fork A new returns mart can ship fast if it clones the customer and product dimensions. It can also ship fast straight into a reconciliation problem. The moment you duplicate definitions, cross-process comparison becomes suspect. The framework Separate processes, shared dimensions Kimball integration keeps facts honest about process while making the main business descriptors reusable. Clone the dimensions Fast locally, expensive globally. Cross-process comparison without semantic drift. Integrate through dimensions, not by pretending every process is one fact table. Set the process boundary 01 Should sales and returns live in the same fact table? Choose the dimension strategy 02…
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in