الطلب
“A financial transactions star schema with FactTransaction linked to Date, Customer, Account, and Product dimensions, storing amount and transaction type.”
جرّب إذنAdd a branch dimensionAdd a fraud flag to FactTransaction
ما الذي يتضمنه هذا الرسم
اقرأ القرارات الكامنة وراءه.
01
Use a fact table for transactions
02
Normalized dimension tables with surrogate keys
03
One-to-many relationships from dimensions to facts
When building a dimensional model for OLAP reporting on transaction data.