The Extract Transform Load (ETL) Process and Optimization using Ab Initio
International Journal for Research in Applied Science and Engineering Technology
Data is everything! In the technological world, this statement holds true. Technology all over the world produces a huge amount of data every day every minute every second. What do we do with this data? This data is used to produce more data that can help businesses all over the world to innovate more and grow. In this process, an ETL tool is used to extract the data from different RDBMS systems and then that data is transformed by applying some calculations etc, and then load the transformed
... d the transformed data into the Data Warehouse. The purpose of this study is to present the structure of ETL process in a structured manner along with optimization of ETL in details. We will be covering how the process of Extraction of data from various sources, transform that data by performing various calculations on it, and loading/storing the data into warehouse for further use takes place and how various tools helped to optimize the ETL process. It is the base of every data warehouse systems, data mining and business intelligence. I.