You are reviewing the design of an existing fact table named factSales, which is loaded incrementally from a SQL Azure database by a SQL Server Integration
Services (SSIS) package each hour. The fact table has approximately 4 billion rows and is dimensioned by product, sales date, and sales time of day.
The database administrator is concerned about the rapid growth of the database and users experience poor reporting performance against this database.
Reporting requirements have recently changed and the only remaining report that uses this fact table reports sales by product name, sale month, and sale year.
No other reports will be created against this table.
You need to reduce the report processing time and minimize the growth of the database.
What should you do?
Comments