O'Reilly logo

Oracle® DBA Guide to Data Warehousing and Star Schemas by Bert Scalzo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required