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
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
○ Or for files: Creating DataSources for File Source Systems
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:
Hello all,
ReplyDeleteA 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