Data Warehouse Design - Search Results

At the highest level, designing a data warehouse involves creating, manipulating, and mapping models. These models are conceptual, logical, and physical (data) representations of the business and end-user information needs. Some models already exist in source systems and must be reverse engineered. Other models, such as those defining the data warehouse, are created from scratch. Creating a data warehouse requires designers to map data between source and target models, capturing the details of the transformation in a meta data repository. Tools that support these various modeling, mapping, and documentation activities are known as data warehouse design tools. Also see the DW Mapping and Transformation subcategory in Data Integration.