Interested to Buy Any Domain ? << Click Here >> for more details...
What are aggregate fact tables ? why they are needed? give
an example
- 2 Answers
- 10706 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 is type 2 version dimension?
Explain what are the possible data marts in retail sales?
What is edw?
Who needs data warehousing?
How to generate iqd file from framework manager?
What is the limit to the number of sources and targets you can have in a mapping?
What is data analysis?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
What are fundamental stages of data warehousing?
Explain vldb?
What function should we use to display the value entered or selected by a user in response to a prompt?
How to design file watch jobs?
What are the types of SCD?
What are the tools available for etl?
What are the various tools? Explain name a few?
