Using requirements gathered in Opportunity Assessment and Business Analysis, the Data Warehouse Architect creates detailed data models for the data warehouse and/or data mart(s) and creates the physical database definitions.
Facts, dimensions, summaries, indexes, loading tables, staging tables and public tables are defined. Sizing estimates are refined. Database ids and security are implemented.
The Data Warehouse Architect works with your company’s Database Administrator (DBA) throughout this process to ensure compatibility with corporate standards and to ensure the DBA will be comfortable supporting the databases into the future.
Data Extract, Transform and Load (ETL)
This service is delivered by an ETL Specialist with assistance from IT and user staff who are very familiar with the data sources and the business rules.
The ETL products are configured to deliver the data from the legacy sources to the data warehouse environment.
Wherever possible, the ETL rules will be stored in a single repository for consistency of definition and ease of maintenance. This is best accomplished with an ETL software tool. In some cases, it may be necessary to use custom business logic, that should be implemented as Stored Procedures and Triggers in the RDBMS. As a last resort, unique requirements may have to be met using a programming language such as C++.