FSA Data Warehouse

• Warehouse Size

  • Salaries/Expense Gen Journal - 15M rows per year
  • CCC Gen Journal - 100M - 200M rows per year
  • Estimated 100 GB of data per year

• Fragmentation Plan

  • by state/division
  • by year and accounting period
  • by fund

Previous slide

Next slide

Back to first slide

View graphic version