Design and Implementation of ETL Tool for Data Warehouse
Download as PDF
DOI: 10.25236/iccpb.2018.020
Author(s)
Jingting Wang, Bao Liu
Corresponding Author
Jingting Wang
Abstract
This paper takes the current business system of automobile department store chain sales service company as an example, and analyzes the problem that the data from multiple data sources cannot directly be loaded into the data warehouse by the current commercial ETL (Extraction-Transformation-Loading, ETL) tool. Firstly, it designs the logical model of ETL tool based on the metadata, then customizes the data cleaning method in ETL tool. Finally, the system experiments are carried out on ETL tool, and the experimental results and analysis are given. Through the development of the ETL tool, an interface is provided for the user-defined data cleaning function, which makes up for the shortage of the custom data cleaning function by the commercial ETL tool, thereby the use efficiency of ETL tool is improved.
Keywords
Data Warehouse, Structured Data, Extraction-Transformation-Loading(ETL), Metadata