OBIEE Datawarehouse Design Process Iterations

OBIEE Data-warehousing Design Process Inception Phase

Designing the Data Warehouse effort:

The Best practice iterations to design a Data warehouse can be as follows

1. Configuring an Oracle or DB2 or MS Sql Server database for use as a data warehouse

2. Designing the Warehouse if the Warehouse supports more than one LOB the Data Modeler can come up with a Physical warehouse design based on Conformed Bus Architecture with conformed dimensions & Conformed facts which allow the IT to reuse the Data sets across the Business.

3. Managing Schema objects such as Tables, Concurrent programs, Sequences, Schema, Disks, Views, Indexes & Materialized Views

4. Managing & Maintaining the User authentication its a DBA responsibility

5. Developing routines, Streams, ETL Process using an ETL tool or a Push Pull concurrent program code to Leverage operational data resemblance

6. Managing change data capture using tools like CA -7 or Siebel DAC & more

7. Creating Metadata repository, BMM Layer Meta data repository, User Authentication & Authorization Strategy through OBIEE or LDAP or Data base authentication.

8. Backing up the data base & Performing recovery & leveraging fault tolerance

9. Monitoring data-warehouse’s performance using OBIEE tool caching & performance tuning strategies

OBIEE Data-warehousing Design Process Inception Phase

Designing the Data Warehouse effort:

The Best practice iterations to design a Data warehouse can be as follows

1. Configuring an Oracle or DB2 or MS Sql Server database for use as a data warehouse

2. Designing the Warehouse if the Warehouse supports more than one LOB the Data Modeler can come up with a Physical warehouse design based on Conformed Bus Architecture with conformed dimensions & Conformed facts which allow the IT to reuse the Data sets across the Business.

3. Managing Schema objects such as Tables, Concurrent programs, Sequences, Schemas, Disks, Views, Indexes & Materialized Views

4. Managing & Maintaining the User authentication its a DBA responsibility

5. Developing routines, Streams, ETL Process using an ETL tool or a Push Pull concurrent program code to Leverage operational data resemblance

6. Managing change data capture using tools like CA -7 or Siebel DAC & more

7. Creating Metadata repository, BMM Layer Meta data repository, User Authentication & Authorization Strategy through OBIEE or LDAP or Data base authentication.

8. Backing up the data base & Performing recovery & leveraging fault tolerance

9. Monitoring data-warehouse’s performance using OBIEE tool caching & performance tuning strategies