New ETL Approach Based on Data Virtualization
Shu-Sheng Guo Zi-Mu Yuan Ao-Bing Sun and Qiang Yue
In this paper, a new ETL approach, TEL (Transform-Extract-Load) is proposed. The TEL approach applies virtual tables to realize the transformation stage before extraction stage and loading stage, without data staging area or staging database which stores raw data extracted from each of the disparate source data systems.