요청 내용
“Create an e-commerce gold-layer star schema with DimDate, DimCustomer, DimProduct, DimPaymentType, and FactOrder tables, the shown keys, attributes, and order measures, with facts linked to customer, product, date, and payment type dimensions.”
그렇다면Add shipment status.Add discount measures.
이 도면에 담긴 내용
그 이면의 의사결정을 읽어 보세요.
01
Chose a star schema over snowflake to simplify analytics and improve query performance.
02
Included a date dimension to enable time-based analysis on orders.
03
Used mandatory relationships to ensure referential integrity in the gold layer.
When designing a data warehouse for e-commerce order analytics with a focus on ease of use and performance.