Interested to Buy Any Domain ? << Click Here >> for more details...
What are aggregate fact tables ? why they are needed? give
an example
- 2 Answers
- 10632 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 is data analysis?
WHAT IS FACT LESS FACT TABLE?
Explain what is the difference between power center & power mart?
What are the fundamental elements of the data warehouse?
in siebel analytics by using dashboard prompts in a page have 2 reports so i have to give dashboard prompt to applied on first report only that will not applied to 2 report how it will do
What is the difference between agglomerative and divisive hierarchical clustering?
What is XMLA ?
How can you clear the cache?
What are the different types of schemas used in data warehousing?
Can a dimension table contain numeric values?
What is a cube in data warehousing concept?
What is the differences between star and snowflake schemas?
Teradata 
