What is a fact table in the context of data warehousing?
- A table that contains numerical or quantitative data
- A table that defines relationships between dimensions
- A table that stores descriptive attributes
- A table that stores historical data
In data warehousing, a fact table typically contains quantitative data related to business processes or events, forming the core of analytical queries. It often contains foreign keys to related dimension tables.
Loading...
Related Quiz
- Apache Airflow provides a ________ feature, which allows users to monitor the status and progress of workflows.
- Which phase of the ETL process involves extracting data from various sources?
- What considerations should be made when selecting between different data modeling tools such as ERWin and Visio for a specific project?
- The process of breaking down data into smaller chunks and processing them individually in a streaming pipeline is known as ________.
- ________ is a data loading strategy where data is continuously loaded into the target system in real-time as it becomes available.