Interested to Buy Any Domain ? << Click Here >> for more details...
What are aggregate fact tables ? why they are needed? give
an example
- 2 Answers
- 10813 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are parallel querys and query hints?
Explain when do we analyze the tables? How do we do it?
What is informatica architecture?
What is degenerate dimension table?
How to handle multi value dimensions?
Where the data cube technology is used?
Compare and contrast aggregates & indexes
Explain what are the modules in power mart?
Explain datawarehousing?
What are the advantages of cold fusion?
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
Explain what is type 2 version dimension?
what is user variable in affinium campaign? and some real time examples.
How can we schedule the graph in unix?
Explain is olap databases are called decision support system true/false?
