General Frame Design for ETL Tools
Long Si-rui · Jisuanji gongcheng · 2003
In the process of importing operational data into data warehouse, two largest challenges will be confronted. One is the integration of heterogeneous muti-data sources and the other is dirty data detection and solution. In this paper, the general frame for ETL tools is designed for pratice. General data access interface is used for shielding the difference among all kinds of data sources and data cleaning is the main purpose in the frame. An effective solution is given for eliminating muti-data sources scheme collision and instance data collision. '