摘要： 阐述了ETL在创建数据仓库过程中的重要地位;分析了整个ETL流程,把它分为数据源验证、数据源改造、一般性变换、装载目标表和数据聚合5个阶段。最后分析了ETL产品现状、现有ETL产品的功能特点,以及今后ETL产品的发展趋势。

关键词: 抽取转换和加载, 数据仓库, 数据集成, 元数据

Abstract: This paper introduces the importance of extract, transform and load (ETL) in the process of building data warehouse, analyses the process of ETL and cuts a full life cycle ETL process into five stages: source verification, source alteration, common interchange, target load determination and aggregation. Finally, it analyses the ETL productions and their function characteristics, and forecastes the future of function trends.

中图分类号: 

• TP311