Results 1 to 5 of 5

Thread: Fact Table vs View...

  1. #1
    Join Date
    Aug 2015
    Posts
    1

    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
    Posts
    5,938
    Should say table is actually storing data, more or less.

  3. #3
    Join Date
    May 2020
    Posts
    5

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,926
    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
    Posts
    5
    A Fact Table without it's associated Dimensions is useless, however you access it.

    This is a Star Schema:

    http://www.parkershannon.net/eda/StarSchema.html

    This is a Data Mart:

    http://www.parkershannon.net/eda/DataMart.html

    This is Dimension:

    http://www.parkershannon.net/eda/Dimension.html

    This is a Fact Table:

    http://www.parkershannon.net/eda/FactTable.html

Posting Permissions

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