In a star schema, what do the fact tables contain?
Practice Questions
1 question
Q1
In a star schema, what do the fact tables contain?
Dimension attributes
Aggregated data
Transactional data
Metadata
Fact tables in a star schema contain transactional data that can be analyzed, often including measures and foreign keys to dimension tables.
Questions & Step-by-step Solutions
1 item
Q
Q: In a star schema, what do the fact tables contain?
Solution: Fact tables in a star schema contain transactional data that can be analyzed, often including measures and foreign keys to dimension tables.
Steps: 5
Step 1: Understand what a star schema is. It is a type of database design used for data warehousing.
Step 2: Identify what a fact table is. A fact table is a central table in a star schema that stores quantitative data.
Step 3: Know that fact tables contain transactional data. This means they hold data about events or transactions that have occurred.
Step 4: Recognize that fact tables include measures. Measures are numerical values that can be analyzed, like sales amounts or quantities sold.
Step 5: Learn that fact tables also have foreign keys. These are links to dimension tables, which provide context to the measures, like time, product, or customer information.
