Interested to Buy Any Domain ? << Click Here >> for more details...
What are aggregate fact tables ? why they are needed? give
an example
- 2 Answers
- 10730 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / omprakash
It is used to improve the performance of sql query
| Is This Answer Correct ? | 7 Yes | 0 No |
What are the difference between snow flake and star schema?
What are session timeout and application timeout?
What is critical column?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
What is data warehouse architecture?
what are the major three types of modeling used?
0 Answers InfoAxon Technologies,
How can you set the client management?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
3.What is fact less fact ?
9 Answers Accenture, HCL, TCS,
Where can one get more info about Data Warehousing?
What are Aggregate tables?
What is the advantages data mining over traditional approaches?
Teradata 
