What are aggregate fact tables ? why they are needed? give
an example
Answer Posted / rofali
In aggregate Fact tables data is aggregated at some level.
for example, we have a fact table for sales in which data
gets stored on daily basis. Now we can make another fact
table for sales which holds the sales data, aggregated at
weekly level. Now if we have to do repoting on weekly basis
we can directly use the aggregated fact table.this will be
the more efficient way.
Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
Explain what is analytical or analytic mean?
Explain where do we use semi and non additive facts?
Explain er diagram?
Explain what are fact, dimension, and measure?
What is the purpose of cluster analysis in data warehousing?
What is the main difference between star and snowflake star schema? Which one is better and why?
Explain what are components of reportnet?
What is surrogate key? Explain with examples.
What is drilling across?
Explain meta data?
Explain the structure of cold fusion?
I have two universes created by two difference database can we join them in designer & report level? How
What is data warehouse architecture?
What is the difference between a primary and secondary actor in use case modeling?
Can we have multiple application.cfm file in an application?