What is a Fact Table in Dimensional Modeling?
- A table that connects dimensions
- A table that stores descriptive attributes
- A table that stores historical data
- A table that stores quantitative, measurable facts
In Dimensional Modeling, a Fact Table stores quantitative, measurable facts about a business process or event. It typically contains foreign keys that reference dimension tables for context.
Loading...
Related Quiz
- What does ACID stand for in the context of RDBMS?
- Scenario: Your company is implementing a data warehouse to analyze sales data from multiple regions. As part of the design process, you need to determine the appropriate schema for the fact and dimension tables. Which schema would you most likely choose and why?
- How does indexing impact write operations (e.g., INSERT, UPDATE) in a database?
- In a streaming processing pipeline, what is a watermark?
- Which of the following is NOT an authentication factor?