DWH Terms
Measure | A property on which calculations (e.g., sum, count, average, minimum, maximum) can be made |
Regular dimension | Standard star dimension |
Time Dimension | A special case of the standard star dimension |
Parent-child dimension | Used to model hierarchical structures. The dimension schema of a parent-child hierarchy depends on a self-referencing relationship present on the dimension main table. For example, the following diagram illustrates the DimOrganization dimension main table in the AdventureWorksDW2012sample database. Read more… |