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.