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.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *