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`	`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_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the join column table
`CHILD_JOIN_TABLE`	`VARCHAR2(30)`	`NOT NULL`	Name of the join column table
`CHILD_JOIN_COLUMN`	`VARCHAR2(30)`	`NOT NULL`	Name of the join column
`CHILD_LEVEL_NAME`	`VARCHAR2(30)`		Name of the child hierarchy level of the join key