ETL
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.
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
- 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 | # |
