Interested to Buy Any Domain ? << Click Here >> for more details...
What are aggregate fact tables ? why they are needed? give
an example
- 2 Answers
- 10819 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 a Data Cube?
What are cluster analysis in data warehousing?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
What are data modeling and data mining?
Explain what are the various transformation available?
What is the difference between mapping parameter & mapping variable in data warehousing?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
What are the various file formats involved in reportnet?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Advantages of de normalized data?
What are the different models used in cluster analysis?
What is aggregate fact table?
Teradata 
