Based on ETL ODS Warehouse Data Query

The ETL is data warehouse is a very important link is the data warehouse system and the foundation of decision support system.How to design efficient ETL process becomes the multitudinous program or data warehouse project is an important problem of the unit.Based on data sources,one is Oracle database is Excel format economic census electronic yearbook of heterogeneous system,this paper puts forward a kind of parallel data extraction,solve the interface design of heterogeneous data sources of data schema matching problem,cleaning,integration and transform,the integration of two kinds of heterogeneous data for the unification of the Oracle data storage,eliminate the heterogeneous data between,to ensure the effective integration of data resources.