Optimization of ETL Work Flow in Data Warehouse
ETL is responsible for extracting the information or data from different several areas and applies some cleaning, customization, transformation function for data and finally loading into the data warehouse. This paper presents, to implement the one ETL scenario with the help of ARKTOS II. It is a stepwise process, firstly to design the conceptual model for the ETL scenario it contains the quick documentation which contains their relationships, attributes and transformation among them. Next one is a formal logical model for the ETL scenario, it contains the flow of data from the sources towards the data warehouse through the transformations and data stores. ETL processes handle the large volume of data, and managing the workload.