Tuesday, November 9, 2010

Datawarehouse step by step

Purpose

To build a data warehouse, you have to execute certain process steps.

Process Flow

 
       1.      Data modeling
     And/or creating InfoCubes
     And/or creating InfoSets
     And/or creating MultiProviders
     Or creating VirtualProviders
       2.      Metadata and Document Management
     Creating documents
       3.      Setting up the source system:
     And/or creating external systems
     And/or creating file systems
       4.      Defining extraction:
     For SAP source systems: Maintaining DataSources
     Or for a SOAP-based transfer of data: Creating XML DataSources
     Or for transferring data with UD Connect: Creating a DataSource for UD Connect
     Or for transferring data with DB Connect: Creating a DataSource for DB Connect
       5.      Defining transformations:
       6.      Defining data distribution:
       7.      Defining the data flow:
       8.      Scheduling and monitoring:
       9.      Performance optimization:
   10.      Information lifecycle management:
   11.      User management:

1 comment:

  1. Hello all,

    A data warehouse is a database used for reporting. The data is uploaded from the operational systems for reporting. The data may pass through an operational data store for additional operations before it is used in the DW for reporting. Thanks a lot......

    Data Extraction Tool

    ReplyDelete