Basics
An accurate
conceptual design is the fundamental requirement for the construction of a
well-documented data mart that completely meets requirements.
Us...
Wed, 30 Jun, 2021 at 12:47 PM
The conceptual representation generated by the DFM consists of a set of fact schemata. Fact schemata basically
model facts, measures, dimensions, and hier...
Thu, 1 Jul, 2021 at 12:42 PM
A measure is a numerical property of a fact and describes a quantitative aspect of a fact that is relevant to analysis. For example, each sale is measu...
Thu, 1 Jul, 2021 at 12:43 PM
A dimension is a fact property with a finite domain and describes an analysis coordinate of the fact. A fact generally has more dimensions that define ...
Thu, 1 Jul, 2021 at 12:43 PM
The term dimensional attributes stands for the dimensions and other possible attributes, always with discrete values, that describe them. Dimensional a...
Fri, 23 Jul, 2021 at 2:48 PM
A hierarchy is a directed tree whose nodes are dimensional attributes and whose arcs model many-to-one associations between dimensional attribute pairs. ...
Thu, 1 Jul, 2021 at 12:43 PM
A conformed hierarchy is one that is shared among two or more fact schemata in a data mart or in different data marts. Creating conformed hierarchies i...
Fri, 23 Feb, 2024 at 5:34 PM