Interested to Buy Any Domain ? << Click Here >> for more details...
What are aggregate fact tables ? why they are needed? give
an example
- 2 Answers
- 10714 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 session timeout and application timeout?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
Explain what are the tasks that loadmanger process will do?
How to create prompts in report net?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
How can we determine what records to extract?
Where the cache files stored?
Explain what are the advantages data mining over traditional approaches?
Explain what are components of reportnet?
Which component has onread method and what it is used for?
What is aggregate fact table?
What is Active Datawarehousing?
Do you view contain data?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
