• Define the architecture, do capacity planning, and select
the storage servers, database and OLAP servers, and
tools.
• Integrate the servers, storage, and client tools.
• Design the warehouse schema and views.
• Define the physical warehouse organization, data
placement, partitioning, and access methods.
• Connect the sources using gateways, ODBC drivers, or
other wrappers.
• Design and implement scripts for data extraction,
cleaning, transformation, load, and refresh.
• Populate the repository with the schema and view
definitions, scripts, and other metadata.
• Design and implement end-user applications.
• Roll out the warehouse and applications.