الطلب
“Create a financial services gold-layer star schema with TransactionFact, DateDim, CustomerDim, AccountDim, and ProductDim tables, the shown keys, attributes, and transaction measures, with each fact linked to date, customer, account, and product dimensions.”
جرّب إذنAdd a branch dimension.Add exchange rates.
ما الذي يتضمنه هذا الرسم
اقرأ القرارات الكامنة وراءه.
01Fact grain
individual transaction
02Dimensions
Date, Customer, Account, Product
03
Surrogate keys for dimensions, foreign keys in fact
When building an analytical data warehouse for financial transaction reporting.