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.