DBA_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:


© Copyright SS64.com 1999-2014
Some rights reserved