烟草数据中心ETL技术应用

摘要

This article briefly introduces the main functions and main implementation methods of ETL, and proposes a method suitable for a sale subject DC project of a domestic provincial company of tobacco. This method can successfully extract basic data and transaction data from systems of city companies to the data warehouse of the provincial company. It plays an important role in the whole DC project and can give some relative experience to the DC project construction of other industries.%简要介绍了ETL技术的主要功能和主要实现方法,并结合国内某烟草省公司数据中心营销主题域建设项目的具体需要,提出了一种适合该项目的具体ETL实现方法,该方法成功将市烟草公司业务系统中主数据和营销业务数据抽取到省公司数据仓库中,对整个数据中心项目的顺利完成起到了至关重要的作用,也对其他行业数据中心建设提供了相关经验.