USER_DIM_JOIN

USER_DIM_JOIN_KEY

Representation of a join between two dimension tables.

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

Related Commands:

Simon Sheppard
SS64.com