Interested to Buy Any Domain ? << Click Here >> for more details...
What are aggregate fact tables ? why they are needed? give
an example
- 2 Answers
- 10618 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 |
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
What is the main difference between schema in rdbms and schemas in datawarehouse?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain what are data marts?
Where we use surrogate key explain with example?
Explain the difference between view and materialized view?
What is drill-through?
What are the different models used in cluster analysis?
Why facts table is useful in representing the data?
Explain why should you put your data warehouse on a different system than your oltp system?
Is union transormation is active transformation?
State any 5 of Cods guidelines of an OLAP system, brief description each?
Teradata 
