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.