数据仓库中ETL技术的探讨与实践

RESEARCH ON TECHNOLOGY OF ETL IN DATA WAREHOUSE AND ITS PRACTICE

支持数据抽取、转换、清洗和装载的工具集对任何数据仓库工程都是一个必不可少的关键部件。本文重点探讨了ETL技术以及ETL工具的选择原则,并结合具体实例详细介绍了ETL过程的设计和实现方法。

The set of tools that supports data extract, transform, cleansing, and loading is a key component of the data warehouse architecture. This paper discusses ETL technology and the principle of selecting the ETL tools and introduces the design and implementation method of ETL process in detail.