what is the difference between aggregate table and fact
table ? how do you load these two tables ?
Answer Posted / chithra. k
Fact tables generally contains 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).
So the difference is in the granularity.Fact tables store
date in more detail level, but in aggregate tables the
granularity is high.
Is This Answer Correct ? | 18 Yes | 2 No |
Post New Answer View All Answers
How to design file watch jobs?
how much memory space occupied real time project (roughly)?
What is core dimension?
After the complete generation of a report who will test the report and who will analyze it?
How can we run the graph?
Explain if a flat file cotains 1000 records how can I get first and last records only?
Explain what are components of reportnet?
What is vldb(very large databases)?
Explain the definition of normalized and denormalized view?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
How to limit the max no of rows retrieved in the report?
What is mean by aggregate aware?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
What are the data marts?
What are the other names given to data warehousing?