Skip to main content
 
  • SPONSOR(S):  Rachel St. Clair
  • DEPT OR DIVISION: ITS Data & Reporting Environments Application Middleware
  • TECHNICAL LEAD:  Terence Costello
  • STATUS: In Progress
  • Project Theme: Serving Our Communities

As the Enterprise Data Warehouse grows, so does the time required to run the ETLs that keep it updated. (An ETL extracts, transforms and loads data from multiple sources to a data warehouse.) This project will redesign the nightly ETL for the Enterprise Data Warehouse to make better use of the after-hours time we have to run the jobs and to make it easier to diagnose problems.