The unique numeric key (ROW_WID) for each dimension table is
generated during the load process. This key is used to join each dimension
table with its corresponding fact table or tables. It is also used to join the
dimension with any associated hierarchy table or extension table. The ROW_WID
columns in the Oracle Business Analytics Warehouse tables are numeric. In every
dimension table, the ROW_WID value of zero is reserved for Unspecified. If one
or more dimensions for a given record in a fact table is unspecified, the
corresponding key fields in that record are set to zero.
No comments:
Post a Comment