Labels:text | screenshot | purple | font | colorfulness 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 qty_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.