ETL
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
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
Extract
Data are read from source systems. Data may be acquired from several sources that use different storage formats.
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.
Load
Data is loaded into the target data warehouse or data mart.
Also see
- Warehouse Builder, Oracle primary ETL tool
- Data Integrator
| 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 | # |
