An e-commerce business wants to analyze their sales data. They have facts like "total sales" and "number of items sold" and dimensions like "time," "product," and "customer." In a star schema, how should these tables be related?
- All dimension tables directly connected to the fact table
- Dimension tables connected in a hierarchy
- Each dimension table connected to all other dimension tables
- No relationships between tables
In a star schema, all dimension tables are directly connected to the fact table, which represents the center of the schema. This design simplifies queries and ensures quick access to data for analytical purposes.
Loading...
Related Quiz
- A retail company is implementing an ETL process for its online sales. They want to ensure that even if the ETL process fails mid-way, they can quickly recover without data inconsistency. Which strategy should they consider?
- In a star schema, the dimension tables are typically _______.
- What potential disadvantage can arise from excessive denormalization of a database?
- The methodology that emphasizes a phased approach to deploying ERP solutions, where each phase is a stepping stone for the next, is called _______.
- Which data warehousing component provides an abstraction layer that sits between the physical database and the user, ensuring that the data accessed is consistent and accurate?