Modified Data Transformation ETL Process for Integration of Business Systems and Creation of Data Warehouses

摘要

This study describes the modified ETL process of transformation and import of data at which the intermediate stage of the loading data ?as is? in the target system was used. Then these data objects were transformed into target system data objects. The proposed transformation approach allows transforming the source objects into the target system objects in the background. The key advantage of the proposed approach is that a few target objects may be created from a single imported one or a few imported objects may be used for creation of a single target one which significantly facilitates the process of integration of business and analytical systems.