Combined star-schema tables
Dimension Load Jobs (JobType = 1 in _Jobs) can load three hierarchy
types.
This table specifies the data table structure for HierarchyType 0 which is for combined star-schema tables. The columns can be in any order and have any name. Additional columns can exist that are ignored if not mapped.
Column content | Type | Description |
---|---|---|
Element names | String(71) | There can be multiple columns of this type. Each column represents a level in the hierarchy. The relationship between the elements of each level on a row in this table defines the parent-child relationships between the elements. These columns and which level they represent are mapped in _HierarchyLevelNames. |
Attribute values | Any | There can be zero, one or many attribute columns per element column. These are mapped in _HierarchyAttributes. |
Any other data | Any | There can be any number of other columns in the table. Any column that is not mapped in _HierarchyLevelNames and _HierarchyAttributes is ignored. |