1. Process flow
    1. Design target object metadata
      1. Tool
        1. Design Center
          1. Dimension Editor
          2. Cube Editor
    2. Extract source metadata
      1. Tool
        1. Design Center
          1. Import Source Metadata
    3. Profile data and Correct data
      1. Tool
        1. Design Center
          1. Profile Editor
          2. Profile
          3. Correction
    4. Map source to target with transformations
      1. Tool
        1. Design Center
          1. Mapping Editor
    5. Validate, generate and deploy the code
      1. Tool
        1. Design Center
          1. Mapping Editor
          2. Validate
          3. Generate
          4. Control Center Manager
          5. Deploy
    6. Extract, transform and load data
      1. Tool
        1. Design Center
          1. Control Center Manager
          2. Execute Mapping
  2. Glossary
    1. Configuration
    2. Cube
    3. Data Warehouse
    4. Data Mart
      1. Independent Data Mart
      2. Dependent Data Mart
    5. Dimension
    6. Fact Table
    7. ETL
    8. Repository
    9. Repository Owner
    10. Repository User
    11. Target User
    12. Snowflake Schema
    13. Staging area
    14. Star Schema
  3. Characteristics
    1. Subject-oriented
    2. Integrated
    3. Time-variant
    4. Nonvolatile
  4. Comparison of Operational database (OpDB) and Data warehouse (DW)
    1. Currency
      1. Current (OpDB)
      2. Historical (DW)
    2. Detail level
      1. Individual (OpDB)
      2. Individual and summary (DW)
    3. Orientation
      1. Process orientation (OpDB)
      2. Subject orientation (DW)
    4. Number of records processed
      1. Few (OpDB)
      2. Thousands (DW)
    5. Normalization level
      1. Mostly Normalized (OpDB)
      2. Mostly Denormalized (DW)
    6. Update
      1. Frequently (OpDB)
      2. Rare (DW)
    7. Data Model
      1. Relational ERD (OpDB)
      2. Relational Star Schema and Multidimension model (DW)
        1. Relational Model
          1. Star Schema
          2. Snowflake Schema
        2. Multidimensional Model
  5. Definition
    1. A central data repository where data from operational databases and other sources are integrated, cleaned and standardized to support decision making.