Modeling and optimization of extraction-transformation-loading (ETL) processes in data warehouse: An overview

ETL processes are responsible for the extraction of data from several sources, their cleansing, their customization and transformation, and finally, their loading into a data warehouse. In this paper we are reviewing the optimization of its execution plan. We review on the optimization of the sequence of the ETL operations involved in the overall process.