Building a Data Warehouse from a Normalized Database. The steps ... This step reflects the information and analytical characteristics of the data warehouse.