2.118 ALL_DIM_JOIN_KEY
ALL_DIM_JOIN_KEY
describes the joins between two dimension tables that are accessible to the current user. The join is always specified between a parent dimension level column and a child column.
Related Views
-
DBA_DIM_JOIN_KEY
describes all such joins in the database. -
USER_DIM_JOIN_KEY
describes all such joins owned by the current user.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the dimension |
|
|
|
Name of the dimension |
|
|
|
Join key ID (unique within a dimension) |
|
|
|
Name of the hierarchy level |
|
|
|
Ordinal position of the key column within the level |
|
|
|
Name of the hierarchy |
|
|
|
Owner of the join column table |
|
|
|
Name of the join column table |
|
|
|
Name of the join column |
|
|
|
Name of the child hierarchy level of the join key |
See Also: