What are aggregate fact tables ? why they are needed? give
an example
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 |
Name a few sectors which use data warehousing?
How are models actually derived?
where exactly in dataware house a confirmed dimension can be created
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
Explain what is power center repository?
Where the applications and where
What is the use of dimensional modeling in data warehousing?
Why is business intelligence (bi) important in data warehousing?
3.What is fact less fact ?
9 Answers Accenture, HCL, TCS,
What are data modeling and data mining? Where it will be used?
What is difference between Mapplet and reusable transformation?
Suppose we want to display zero when null values coming to report how can we do that?