Results 1 to 5 of 5

Thread: Fact Table vs View...

  1. #1
    Join Date
    Aug 2015

    Fact Table vs View...

    Hello, big newbie here, just want to make sure I understand a simple concept.

    A view is not actually storing the data in a table, its just like a report/query within the database whereas a Fact table is actually storing more data (but most likely in an aggregated way)? Is that correct (in simple terms).

    At first I thought why can't a Fact Table just be a View, but then I realized a View isn't actually storing data like a Fact table is, its just a plain ol' query.

    Thanks All.

  2. #2
    Join Date
    Sep 2002
    Should say table is actually storing data, more or less.

  3. #3
    Join Date
    May 2020

  4. #4
    Join Date
    Nov 2002
    New Jersey, USA
    Fact table is Star Schema concept, where you have transactions in Fact table and Dimension tables have various way you can slice the data in fact table. Since star schema is a data warehouse concept, it is supposed to have have massive amount of data and meant for reporting and data analytics. So creating a view for fact table is not good fit.

  5. #5
    Join Date
    May 2020
    A Fact Table without it's associated Dimensions is useless, however you access it.

    This is a Star Schema:

    This is a Data Mart:

    This is Dimension:

    This is a Fact Table:

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts