Home >
Oracle >
Oracle Data Warehousing: ETL Specifically
Oracle Data Warehousing: ETL Specifically
| Course Code: |
OWHETL |
| Currency: |
10g & 11g |
| Duration: |
3 days (hands-on machine workshop) |
| Audience: |
DW administrators, DBAs, data architects, DW PL/SQL developers. |
| Prerequisites: |
Completion of our course Data Warehouse Terms, Concepts & Architecture
or equivalent knowledge. |
| Summary: |
This course focuses on the extract, transform and load (ETL) phase of the data warehouse (DW)
development life cycle. After discussing ETL as it relates to all DBMSs (DB2, MS Server, Sybase, etc.)
we elaborate on Oracle's ETL offering:
- Change Data Capture
- SQL*Loader
- Data Pump
- External tables
- Transportable tables
- SQL MERGE
- Table Functions
- Etc.
|
| Objectives: |
Upon completion of this presentation, the participant should understand the ETL phase of the
data warehouse development life cycle.
|
Detailed Outline |
|