Detail Design

In the Detail Design stage, the physical Data Warehouse model (database schema) is developed, the metadata is defined, and the source data inventory is updated and expanded to include all of the necessary information needed for the subject area implementation project, and is validated with users. Finally, the detailed design of all procedures for the implementation project is completed and documented.

Procedures to achieve the following activities are designed:

- Warehouse Capacity Growth

- Data Extraction/Transformation/Cleansing

- Data Load

- Security

- Data Refresh

- Data Access

- Backup and Recovery

- Disaster Recovery

- Data Archiving

- Configuration Management

- Testing

- Transition to Production

- User Training

- Help Desk

- Change Management