Transformational

• How Operational (Source) Data is Mapped & Transformed to the Data Warehouse (Target)
• Includes Data Integration, Cleansing, Aggregation, Time Series, etc.
• User Defined / MIS Maintained

Physical

• How the Data is Physically stored
• Database Schema of Tables, Columns & Attributes
• Physical Management of the Data Warehouse
• MIS Oriented

Informational

• Defines & Describes the Availability, Content and Context
• Facilitates Information Exploration and Extrapolation
• Documents and Catalogs knowledge about the Data Warehouse
• Business User Oriented