Which table in a data warehouse provides context to the facts and is often used for filtering and grouping data in queries?
- Aggregate table
- Dimension table
- Fact table
- Reference table
The dimension table in a data warehouse provides context to the facts. It contains descriptive attributes and hierarchies that are used for filtering and grouping data in queries. This helps analysts and users understand the data in the fact table and answer various business questions.
Loading...
Related Quiz
- Which service provides fully managed, performance-tuned environments for cloud data warehousing?
- How does logical modeling differ from physical modeling in terms of its audience or target stakeholders?
- Which strategy involves adding more machines or nodes to a system to handle increased load?
- Which module in an ERP system typically manages human resources, payroll, and benefits?
- A company wants to analyze its sales data over the past decade, broken down by region, product, and month. What data warehousing architecture and component would best support this analysis?