Extract, transform and load (ETL) is a process that makes it possible to extract data from operational data sources, to transform data in the way needed for data warehousing purposes and to load data into a data warehouse (DW). ETL process is the most important part when building the data warehouse. Because the ETL process is a very complex and time consuming, this paper presents a prototype of a web ETL tool that offers step-by-step guidance through the entire process to the end user. This ETL tool is designed as a web application so users can save time (and space) required for installation purposes.
[1]
W. H. Inmon,et al.
Building the Data Warehouse,3rd Edition
,
2002
.
[2]
Mohd Syazwan Abdullah,et al.
Extending ETL framework using service oriented architecture
,
2011,
WCIT.
[3]
Paulraj Ponniah,et al.
Data warehousing fundamentals : a comprehensive guide for IT professionals
,
2001
.
[4]
Luca Faust.
Building And Maintaining A Data Warehouse
,
2016
.
[5]
Ralph Kimball,et al.
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data
,
2004
.