ETL Process Study in Data Warehouse

Based on the implement of the trade business decision support system,this paper studies how to design a good ETL(Extract,Transform,Load) solution to solve the difference of data quantity and the lacking of consistency of the database system which come from different application system and different of data platform;the paper also discusses how to load the data from different application system and transform the data type that the target system want to and load the data to the data warehouse;at last the ETL process provides the foundation data of the high quantity.