Design and Implementation of a Data Warehouse ETL Tray Program

Zhi Gang Yang,Li Sun,Xiao Yang Yu
DOI: https://doi.org/10.4028/www.scientific.net/amm.385-386.1684
2013-01-01
Applied Mechanics and Materials
Abstract:This paper presents an ETL system for a data warehouse designed for a PVC profile manufacturing enterprise. The system implements the data extraction, data transformation and load from the data sources of ERP system, CRM system and production line operation data collection system. The ETL requirements are discussed. The system design and implementation methods, including system structure, functions, data processing methods as well as tray program implementation are addressed.
What problem does this paper attempt to address?