Information Systems Education Journal, ISSN: 1545-679X
 

Home

Indexes

Issue Number Index

Title Index

Keyword Index

Author Index

Institution Index

City/State Index

Browse Prev
ISEDJ 1(9)

Browse Next
ISEDJ 1(11)

  

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. (Also appears in The Proceedings of ISECON 2003: §3521. ISSN: 1542-7382.)
logoPublished by EDSIG, the Education Special Interest Group of AITP, the Association of Information Technology Professionals (Chicago, Illinois).

Comments and corrections to
webmaster@isedj.org