In Dimensional Modeling, a _______ table contains descriptive attributes used for analysis.
- Dimension
- Fact
- Lookup
- Reference
In Dimensional Modeling, a Dimension table contains descriptive attributes used for analysis. These attributes provide context and additional information about the measures in the Fact table. For example, in a sales data warehouse, a Date Dimension table might contain attributes like year, quarter, and month.
Loading...
Related Quiz
- _______ is a mechanism used in NoSQL databases to detect and resolve conflicts in data versions.
- Which stage of database development involves transforming a high-level conceptual model into a detailed physical model?
- Which of the following is NOT a commonly used partitioning method?
- Which UML diagram is typically used for modeling the relationships between objects?
- Dimension tables typically contain _______ data that provides context to the metrics in the fact table.