Overview#Extract Transform Load (ETL) is a data process especially common with a data warehouse.
Extract Transform Load process became a popular concept in the 1970s and consists of:
- Data extraction is where data is extracted from structured data or unstructured data sources
- Data transformation where the data is transformed for storing in the proper schema for the purposes of querying and analysis
- Data loading where the data is loaded into the final target database (typically referred to as a Data warehouse)