One of the main uses of a data warehouse is to sum up fact
data with respect to a given dimension, for example, by date or by sales
region. Performing this summation on-demand is resource-intensive, and slows
down response time. The Oracle Business Analytics Warehouse precalculates some
of these sums and stores the information in aggregate tables. In the Oracle
Business Analytics Warehouse, the aggregate tables have been suffixed with _A.
No comments:
Post a Comment