Keyword: DIMENSION
jump to Columns back to indexTables
| Table Name | Description |
|---|---|
| ALL_DIM_ATTRIBUTES | Representation of the relationship between a dimension level and a functionally dependent column |
| ALL_DIM_CHILD_OF | Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension |
| ALL_DIM_HIERARCHIES | Representation of a dimension hierarchy |
| ALL_DIM_JOIN_KEY | Representation of a join between two dimension tables. |
| ALL_DIM_LEVELS | Description of dimension levels visible to DBA |
| ALL_DIM_LEVEL_KEY | Representations of columns of a dimension level |
| DBA_DIM_ATTRIBUTES | Representation of the relationship between a dimension level and a functionally dependent column |
| DBA_DIM_CHILD_OF | Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension |
| DBA_DIM_HIERARCHIES | Representation of a dimension hierarchy |
| DBA_DIM_JOIN_KEY | Representation of a join between two dimension tables. |
| DBA_DIM_LEVELS | Description of dimension levels visible to DBA |
| DBA_DIM_LEVEL_KEY | Representations of columns of a dimension level |
| USER_DIM_ATTRIBUTES | Representation of the relationship between a dimension level and a functionally dependent column |
| USER_DIM_CHILD_OF | Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension |
| USER_DIM_HIERARCHIES | Representation of a dimension hierarchy |
| USER_DIM_JOIN_KEY | Representation of a join between two dimension tables. |
| USER_DIM_LEVELS | Description of dimension levels visible to DBA |
| USER_DIM_LEVEL_KEY | Representations of columns of a dimension level |
Columns
| Column Name | Description |
|---|---|
| DIMENSION_NAME (ALL_DIM_LEVEL_KEY) | Name of the dimension |
| DIMENSION_NAME (DBA_DIMENSIONS) | Name of the dimension |
| DIMENSION_NAME (DBA_DIM_LEVEL_KEY) | Name of the dimension |
| DIMENSION_NAME (USER_DIM_ATTRIBUTES) | Name of the dimension |
| DIMENSION_NAME (USER_DIM_LEVELS) | Name of the dimension |
| DIMENSION_NAME (ALL_DIM_JOIN_KEY) | Name of the dimension |
| DIMENSION_NAME (USER_DIM_CHILD_OF) | Name of the dimension |
| DIMENSION_NAME (ALL_DIMENSIONS) | Name of the dimension |
| DIMENSION_NAME (DBA_DIM_ATTRIBUTES) | Name of the dimension |
| DIMENSION_NAME (ALL_DIM_ATTRIBUTES) | Name of the dimension |
| DIMENSION_NAME (DBA_DIM_LEVELS) | Name of the dimension |
| DIMENSION_NAME (ALL_DIM_LEVELS) | Name of the dimension |
| DIMENSION_NAME (ALL_DIM_CHILD_OF) | Name of the dimension |
| DIMENSION_NAME (USER_DIM_JOIN_KEY) | Name of the dimension |
| DIMENSION_NAME (USER_DIMENSIONS) | Name of the dimension |
| DIMENSION_NAME (ALL_DIM_HIERARCHIES) | Name of the dimension |
| DIMENSION_NAME (DBA_DIM_JOIN_KEY) | Name of the dimension |
| DIMENSION_NAME (DBA_DIM_HIERARCHIES) | Name of the dimension |
| DIMENSION_NAME (USER_DIM_HIERARCHIES) | Name of the dimension |
| DIMENSION_NAME (USER_DIM_LEVEL_KEY) | Name of the dimension |
| DIMENSION_NAME (DBA_DIM_CHILD_OF) | Name of the dimension |
| DIM_KEY_ID (DBA_DIM_JOIN_KEY) | Join key ID (unique within a dimension) |
| DIM_KEY_ID (USER_DIM_JOIN_KEY) | Join key ID (unique within a dimension) |
| DIM_KEY_ID (ALL_DIM_JOIN_KEY) | Join key ID (unique within a dimension) |