What is the primary function of a fact table in a data warehouse?
- Store descriptive attributes
- Store historical data
- Store metadata
- Store transactional data
The primary function of a fact table in a data warehouse is to store transactional data, which typically consists of numerical values called facts. Fact tables contain foreign keys that link to dimension tables, allowing analysts to perform analysis and generate insights based on various dimensions.
Loading...
Related Quiz
- Scenario: A social media platform tracks users and their posts. Each user can have multiple posts, and each post can have multiple comments. How would you model this relationship in an ERD?
- What is the typical scope of a Data Warehouse?
- The use of inheritance in database modeling can lead to _______ in querying and maintenance.
- A healthcare organization is building a data warehouse to analyze patient admissions. It has a fact table containing admission dates, discharge dates, and lengths of stay. How would you design the dimension tables to support this fact table?
- What is meant by the term "attribute" in an ERD context?