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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.