Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
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.
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 |
VARCHAR2(30) |
NOT NULL |
Owner of the dimension |
DIMENSION_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the dimension |
DIM_KEY_ID |
NUMBER |
NOT NULL |
Join key ID (unique within a dimension) |
LEVEL_NAME |
VARCHAR2(30) |
Name of the hierarchy level | |
KEY_POSITION |
NUMBER |
NOT NULL |
Ordinal position of the key column within the level |
HIERARCHY_NAME |
VARCHAR2(30) |
Name of the hierarchy | |
CHILD_JOIN_COLUMN |
VARCHAR2(30) |
NOT NULL |
Name of the join column |