|
A:
|
The short answer is no. To determine if a data warehouse must be built to support analytics:
- First business requirements must be captured and analyzed to determine what the analytic work load looks like.
- Then models should be developed to understand what is required to satisfy the business requirements.
- Next, the source database utilization needs to be analyzed to determine what if any additional workload (analytic) it can support.
In some cases, a mix of source system database access, bridge tables and materialized views can be employed to satisfy most of the business requirements. In other cases, a full blown data warehouse or data mart must be developed.
|
