DBA_DIM_JOIN

DBA_DIM_JOIN_KEY

Representation of a join between two dimension tables.

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

Related Commands:

Simon Sheppard
SS64.com