Data Warehouse Design Considerations
Warehouse Size
- General Journal - 22 million rows per year
- Financial Detail - 5.5 million rows per year
- Labor Detail - 7 million rows per year
- Planned for 10 years of data
Fragmentation Plan Across 24 dbspaces
- by state/division
- by year =< 1997 or > 1997