Mini-dimension tables include
combinations of the most queried attributes of their parent dimensions. They
improve query performance because the database does not need to join the fact
tables to the big parent dimensions but can join these small tables to the fact
tables instead.
lists the mini-dimension tables in the Oracle
Business Analytics Warehouse.
|
Table Name
|
Parent Dimension
|
|
W_RESPONSE_MD
|
Parent W_RESPONSE_D
|
|
W_AGREE_MD
|
Parent W_AGREE_D
|
|
W_ASSET_MD
|
Parent W_ASSET_D
|
|
W_OPTY_MD
|
Parent W_OPTY_D
|
|
W_ORDER_MD
|
Parent W_ORDER_D
|
|
W_QUOTE_MD
|
Parent W_QUOTE_D
|
|
W_SRVREQ_MD
|
Parent W_SRVREQ_D
|
No comments:
Post a Comment