Interested to Buy Any Domain ? << Click Here >> for more details...
What are aggregate fact tables ? why they are needed? give
an example
- 2 Answers
- 10628 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 does level of granularity of a fact table signify?
Explain what is partitioning? What are the types of partitioning?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
What is Active Datawarehousing?
Tell me one example for junk dimension?
What are data modeling and data mining?
Best Data Ware housing training institute in delhi
Explain swot analysis?
What is Conceptual, Logical and Physical model?
What is a ETL/ How does Oracle support the ETL process?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
Explain where do we use semi and non additive facts?
Teradata 
