A new tool for ETL process
Zuyi Chen, Taixiang Zhao · 2012
The data warehouse has increasingly become a focus of the database industry. A data warehouse is a collection of data from different sources that supports analytical querying. It constitutes the background to enable business intelligence solutions. In order to supply a decisional database, meta-data is needed to enable the communication between various function areas of the warehouse and an ETL (Extraction, Transformation, and Load) tool is needed to define the warehousing process. In this paper, we will use a model to create an active ETL tool. In our approach, we use queries to achieve the warehousing process. SQL queries will be used to represent the mapping between the source and the target data.