ALL_DIM_JOIN

ALL_DIM_JOIN_KEY

Representation of a join between two dimension tables.

Columns
   ___________________________
 
   OWNER
      Owner of the dimension
   HIERARCHY_NAME
      Name of the hierarchy
   KEY_POSITION
      Position of the key column within the level
   LEVEL_NAME
      Name of the hierarchy level
   DIMENSION_NAME
      Name of the dimension
   CHILD_JOIN_COLUMN
      Name of the join column
   DIM_KEY_ID
      Join key ID (unique within a dimension)

Related Commands:

Simon Sheppard
SS64.com