The Oracle Sponge

Oracle Data Warehouse Design and Architecture

Archive for August 15th, 2006

Year-to-Date Query Improvement Through Transformation Tables

Posted by David Aldridge on 2006-08-15

A quick comparison here between two methods of deriving year-to-date metric values from a data warehouse fact table.

Suppose we have a simple fact table of the following form: Read the rest of this entry »

Posted in Data Warehousing, Performance | 19 Comments »