From Oracle FAQ
ETL refers to the Data Warehouse data acquisition processes of Extracting, Transforming (or Transporting) and Loading (hence ETL) from source systems into a data warehouse or data mart.
Data are read from source systems. Data may be acquired from several sources that use different storage formats.
Data is moved from the source to the target systems and is cleaned-up and changed to accommodate the data structures on the target system.
Data is loaded into the target data warehouse or data mart.
- Warehouse Builder, Oracle primary ETL tool
- Data Integrator
|Glossary of Terms|