Home Oracle Commands Oracle Data Dictionary
 v$ Performance views

USER_DIM_JOIN_KEY

Representation of a join between two dimension tables. 

Columns
   ___________________________
 
   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
   CHILD_JOIN_COLUMN
      Name of the join column

Related:


Simon Sheppard
SS64.com