ocr: category shrunken aggregate Product category Sales fact table dimension table time dimension table time key category_key category_key category store dimension.table store key department promo key promo dimension table gty_sold dollars sold dollars cost FIGURE 3 The same data warehouse showing the ag- gregates in a separate category aggregate fact table and a shrunken product category dimension table.
