What is a 'fact table' in a data warehouse and how does it differ from a 'dimension table'?
- Fact table contains descriptive data, whereas dimension tables contain quantitative data.
- Fact table contains quantitative data and is connected to dimension tables, whereas dimension tables provide descriptive information about data in the fact table.
- Fact table is used for historical data, whereas dimension table is used for real-time data.
- Fact table is used for indexing, whereas dimension table is used for primary storage.
A 'fact table' in a data warehouse contains quantitative data and is connected to dimension tables, which provide descriptive information about the data in the fact table. The fact table is the core of the data warehouse and supports analytics.
Loading...
Related Quiz
- How would you approach a time series analysis for predicting energy consumption patterns in a city with rapidly changing weather conditions?
- What is the first step typically taken in the data cleaning process?
- In a typical database, what data type is commonly used to store large text such as comments or descriptions?
- What is the primary purpose of using a version control system like Git in software development?
- In cloud-based data analysis, _______ is a critical feature that ensures data privacy and regulatory compliance.