Volume 1

Volume 1, Number 10

September 12, 2003

10 pages595 K bytes

Extraction, Transformation, and Loading in a Data Warehouse Course

Edward A. Boyno
Montclair State University
Upper Montclair, NJ 07043

Abstract: This paper describes my experiences teaching a unit on Extraction, Transformation and Loading as part of a course on Data Warehousing. After a brief discussion of the process in general, it concentrates on one of the more interesting parts of that process, Data Cleansing. Some of the problems that may occur during Data Cleansing are discussed as well as some of the techniques that might be used to address them. Student exercises, some elementary, some more challenging, are presented and discussed. Finally, the paper addresses some of the problems I encountered and possible future work.

Keywords: extraction, transformation, loading, ETL, data warehouse, data cleansing, data scrubbing, CS education, IS education

Download this issue:   ISEDJ.1(10).Boyno.pdf   (Adobe PDF, 10 pages, 595 K bytes)

Preview the contents:   Boyno.txt   (ASCII txt, 22 K bytes)

Recommended Citation: Boyno (2003). Extraction, Transformation, and Loading in a Data Warehouse Course. Information Systems Education Journal, 1 (10). http://isedj.org/1/10/. ISSN: 1545-679X. (A preliminary version appears in The Proceedings of ISECON 2003: §3521. ISSN: 1542-7382.)