What is the main purpose of a fact table in Dimensional Modeling?
- Store descriptive attributes
- Store hierarchies
- Store quantitative data
- Store transactional data
The main purpose of a fact table in Dimensional Modeling is to store quantitative data, typically numerical values that represent business facts. These facts are often measures such as sales, revenue, or quantities. Fact tables are linked to dimension tables, providing context and additional details for the stored facts, facilitating meaningful analysis.
Loading...
Related Quiz
- Scenario: A software development team is working on a new project. They need to design the database schema. Which data modeling language would you recommend they use, and why?
- Column-family stores are optimized for _______ and _______.
- How does eventual consistency differ from strong consistency in NoSQL databases?
- Which NoSQL database type is most suitable for graph-based data modeling?
- A large e-commerce website experiences slow query performance due to a massive volume of customer data. What relational schema design technique could you employ to optimize storage and enhance query performance?