1) Fact tables generally contain measures and the composite key, which is generally a combination of foreign keys from the respective dimension tables. Aggregate tables are summary tables which contains the summary information say for eg: total sales revenue (for a quarter).
2) So the difference is in the granularity. Fact tables store date in more detail level, but in aggregate tables the granularity is high.
No comments:
Post a Comment