Oracle Data Warehousing: ETL Specifically
Course
In Gatwick
Description
-
Type
Course
-
Location
Gatwick
-
Duration
4 Days
Upon completion of this presentation, the participant should understand the ETL phase of the data warehouse development life cycle. Suitable for: DW administrators, DBAs, data architects, DW PL/SQL developers.
Facilities
Location
Start date
Start date
About this course
Completion of our course Data Warehouse Terms, Concepts & Architecture or equivalent knowledge.
Reviews
Course programme
Currency:
10g & 11g
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 SQL 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.
Oracle Data Warehousing: ETL Specifically