요청 내용
“Create a retail sales gold-layer star schema with dim_date, dim_product, dim_store, dim_customer, and fact_sales tables, the shown keys, attributes, and sales measures, with each fact linked to its date, product, store, and customer dimensions.”
그렇다면Add a promotion dimension.Add return transactions.
이 도면에 담긴 내용
그 이면의 의사결정을 읽어 보세요.
01
Use surrogate keys for each dimension to decouple from source systems.
02
Include a transaction_id in the fact table to link back to operational systems.
03
Define relationships with mandatory one-to-many cardinalities from fact to dimensions.
When building a dimensional model for retail sales reporting in a data warehouse or lakehouse environment.