Interested to Buy Any Domain ? << Click Here >> for more details...
What are aggregate fact tables ? why they are needed? give
an example
- 2 Answers
- 10720 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 what are the advantages data mining over traditional approaches?
DWH architecture?
How to generate the cubes in framework manager?
What is an OLTP (Online Transaction Processing) System?
What is a fact, dimension, measure?
Explain what is the metadata extension?
Compare ?Data mining? and ?Data Warehousing??
What is the differences between star and snowflake schemas?
What is the difference between OLAP, ROLAP, MOLAP and HOLAP?
List any five applications of data warehouse.
Explain grouped cross tab?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Teradata 
