Volume 1
Volume 1, Number 10 |
September 12, 2003 |
|
Edward A. Boyno
|
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.)