Browse Prior Art Database

A Mechanism for Programming Error Recovery for Data Warehouse Processes

IP.com Disclosure Number: IPCOM000018880D
Original Publication Date: 2003-Aug-19
Included in the Prior Art Database: 2003-Aug-19

Publishing Venue

IBM

Abstract

ETL (extract, transform & load) is a standard means of programming the loading of data into a data warehouse. This disclosure presents a technique to allow user-defined error handlers for ETL processes. The necessary error control itself need not be custom-coded for each ETL step but a single ETL Controller can be re-used across all the ETL steps in the ETL project.