How Does Extract Transform Load Help In Data Warehousing: Enhancing Data Warehousing with Extract Transform Load

Abstract

The data warehouse is the centralizedrepository which stores the data from multiple information sources and thentransforms it into the common and multidimensional data model for the efficientquerying and analysis. ETL is one of the tools that are used by data warehouseand ETL helps data to perform its operations flexible and consistent and alsomore efficient. ETL (Extraction, transformation, and loading) takes place inthe data warehouse, when the data warehouse is populated for first time andalso it takes place regularly at the time of updating the data warehouse. ETLtools provide more value to the data warehousing.