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.

New ETL Approach Based on Data Virtualization