-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|