- SPONSOR(S): Rachel St. Clair
- DEPT OR DIVISION: ITS Data and Reporting Environments and Application Middleware
- PROJECT OWNER: Terence Costello
- STATUS: Completed
- 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.