Oracle9i OLAP User's Guide Release 2 (9.2) Part Number A95295-01 |
|
OLAP Catalog Union Views , 23 of 24
ALL_OLAP2_JOIN_KEY_COLUMN_USES
is a synonym for ALL$OLAP2UJOIN_KEY_COLUMN_USES
.
Each row represents the key information that joins two levels in a hierarchy. If the level is mapped to more than one column, each column mapping is represented in a separate row in the view.
In a snowflake schema, where levels are defined in separate dimension tables, levels in a hierarchy have a logical foreign key relationship. In a star schema, where levels are defined within the same dimension table, the child level key specifies its position in the hierarchy.
|
Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. |
|