Aggregation by Itself
Now that all your options have been clearly spelled out, the reality is that there is really only one choice. Do not treat the aggregation process as part of the fact table data loading process (that's exactly why they're separate chapters in this book). Simply treat aggregation as its own distinct phase in the overall process (i.e., data load, then aggregate), as shown in Figure 7-4
Figure 7-4. Simply Treat Aggregation Process by Itself
The astute observer will recognize that this was exactly what was being shown by a portion of the second option in both Figures 7-2 and 7-3. Look back and you'll see that by simply removing ...
Get Oracle® DBA Guide to Data Warehousing and Star Schemas now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
