ETL

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.

Contents

[edit] ETL processes

[edit] Extract

Data are read from source systems. Data may be acquired from several sources that use different storage formats.

[edit] Transform

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.

[edit] Load

Data is loaded into the target data warehouse or data mart.

[edit] Also see

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 #