Scenario: A financial institution requires a data warehouse to analyze customer transactions and account balances over time. How would you utilize Dimensional Modeling principles to design the data model?
- Fact table for customers, dimensions for transactions and time
- Fact table for time, dimensions for customers and transactions
- Fact table for transactions, dimensions for customers and time
- No need for Dimensional Modeling in financial analysis
For a financial institution analyzing customer transactions and account balances, a Fact table for transactions with dimensions for customers and time is suitable. This allows for detailed analysis based on customer transactions over time.
Loading...
Related Quiz
- How does a Data Mart differ from a Data Warehouse in terms of data volume and specificity?
- In document-based modeling, what is denormalization and how does it differ from normalization?
- How can database partitioning enhance performance tuning efforts?
- What does data integrity ensure in a database system?
- Which type of consistency model ensures that all reads reflect the most recent write for a given data item in a distributed system?