The logical data model used within the Data Warehouse layer, which is focused more on business processes and less on the source systems from which the data originates. The dimensional model contains both dimension and fact information.
Represents a set of related attributes that can be used to analyze data in the dimensional model. For example, the Adventure Works model contains a Product dimension, which enables analysis of data by product attributes.
A descriptive characteristic included in a dimension. For example, in the Adventure Works model the Product dimension contains Product, Category, and Subcategory attributes.
Representation of a business process or event ...