what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 51161 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / santosh
The difference that i know is that the aggregate tables
contain only the summaries of the data where as the fact
tables contain summaries and measures. i.e.,the grain of
the data present in fact table is more than the grain of
the data present in aggregate tables.
| Is This Answer Correct ? | 15 Yes | 5 No |
Post New Answer View All Answers
Explain the structure of cold fusion?
What is batch processing?
Explain what is the difference between datawarehouse and bi?
Why is dimensional normalization not required?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
How many types of facts and what are they?
What are algorithms provided by Microsoft in SQL Server?
What is the difference between static cache and dynamic cache?
Explain the difference between dw and bi?
Explain difference between view and materialized view?
What is many-to-many dimensional model in datawarehousing ?
Explain what are non-additive facts?
How to generate iqd file from framework manager?
Explain what is partitioning? What are the types of partitioning?
Difference between cold fusion mx 6 and cold fusion mx 7?
