From Oracle FAQ
Jump to: navigation, search

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.

ETL processes[edit]


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.

Also see[edit]

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #