Question: what is the difference between aggregate table and fact table?
Answer: For example, sales data is stored by day in a fact table. ... If the daily sales fact table is the lowest-level fact table and contains atomic-level data, it is referred to as a base table. In these terms, an aggregate table is any fact table whose data is derived by aggregating data from an existing base table.