Interested to Buy Any Domain ? << Click Here >> for more details...
What are aggregate fact tables ? why they are needed? give
an example
- 2 Answers
- 10601 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 necessary tasks to install reportnet software?
How to know the time taken for particular report execution?
Explain what is fact less fact table? Where you have used it in your project?
How to define a cube??
Explain the definition of normalized and denormalized view and what are the differences between them?
Best Data Ware housing training institute in delhi
Where can one get more info about Data Warehousing?
How do you define data block size?
What is the difference between a W/H and an OLTP application?
Explain the data type of the surrogate key?
What are session timeout and application timeout?
What is batch processing?
Teradata 
