Table: DBA_DIM_JOIN_KEY
Representation of a join between two dimension tables.
| Column Name | Description |
|---|---|
| CHILD_JOIN_COLUMN | Name of the join column |
| DIMENSION_NAME | Name of the dimension |
| DIM_KEY_ID | Join key ID (unique within a dimension) |
| HIERARCHY_NAME | Name of the hierarchy |
| KEY_POSITION | Position of the key column within the level |
| LEVEL_NAME | Name of the hierarchy level |
| OWNER | Owner of the dimension |