|
There are many different approaches depending upon your situation. Please refer to the BI architecture components and BI architecture scenario, before you look at the answer. Some examples are:
- Let the Data Mart OLAP sit over the top of new Data Warehouse Database. You will do this, if your data mart is functioning well. In this case, your ETL and Dimensional Data base (from where OLAP server picks the data) will be changed.
- If you are creating a new data marts which have a significantly overlap with the existing Data Mart, you may create a new Data Mart. This will includes migrating the data from the OLAP server and loaded areas of the existing data mart to the new data mart OR recreating the entire Data Mart.
- Sometime you leave the entire infrastructure of the existing data mart (ETL, Loading area, and OLAP) alone. You implement the data warehouse and over time move the data mart to the data warehouse environment.
There are many possible solutions, and it depends upon your organization context. Few desirable approaches:
- Integrate the ETL first. Extraction, Transformation and Loading are the key to the Data Warehouse infrastructure and there a consistency and commonality, will help you accelerate the integration at OLAP and End-user tools level.
- Plan ahead- Give a thought on your integration path, much before you start doing the modeling and planning.
|
