What are aggregate fact tables ? why they are needed? give
an example
- 2 Answers
- 9744 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 |
Explain vldb?
Which is the optimized method of extracting the data.
In datastage can ve find the job based on source table name ??
Explain which are the olap tools available that are supported by oracle?
Explain why denormalization is promoted in universe designing?
WHAT IS FACT LESS FACT TABLE?
Define data warehouse?
How to use the tool Ontobulider
Explain the versions of reportnet?
Which columns go to the fact table and which columns go the dimension table?
What is the advantages data mining over traditional approaches?
Fact table is in normalized or de-normalized form?
Teradata 
