Advanced ETL (AETL) by integration of PERL and scripting method

Abstract

Enhancing ETL (Extraction, Transformation and Loading) process framework data streams can give better profit for your Business venture. An endeavor level planning arrangement that is anything but difficult to utilize and handles heterogeneous situations may simply do what you require. Before, the attention was for the most part on business process plan, demonstrating. As of late, ventures have understood that they can advantage immensely from mechanizing the ETL process with the target of streamlining or enhancing them. With a specific end goal to extract, transform and load huge scale of data from miscellaneous data sources into data warehouse effectively, AETL come into existence and designed in this paper by using of PERL subroutine, data partition with integration of scripting method. The main function of AETL is to boost the efficiency of ETL and increase processing speed.