What is Extraction, transformation, and Loading (ETL)?

ETL is the process of populating the data warehouse from one or multiple sources. – Copy data from its source(s) to the DW. Extraction: is the process of identifying data sources and copying the data required for analysis. – Data copied to the staging area Transformation: is the process of mapping and harmonizing the data that is, making certain the data are consistent, cleansed, and reliable—from their sources to the targets. – Convert the data to the required form Loading: is moving data from the staging area to the DW