ORACLE DATA WAREHOUSE DESIGN - ETL
Duration: 3 Days
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:
Topics Covered In This Course
REVIEW OF DATA WAREHOUSING (DW) TERMS AND CONCEPTS
EXTRACT, TRANSFORM, LOAD (ETL) TERMS and CONCEPTS
DATA CLEANING and CONFORMING
DIMENSION TABLE DELIVERY
SLOWLY CHANGING DIMENSIONS
FACT TABLE DELIVERY
FACT TABLE LOAD CONSIDERATIONS
ORACLE'S DATA EXTRACTION
ORACLE'S DW LOADING OPTIONS
ORACLE DATA TRANSFORMATIONS and CLEANING
DW PERFORMANCE and GOOD PRACTICES
What You Can Expect
Upon completion of this presentation, the participant should understand the ETL phase of the data warehouse development life cycle.
Who Should Take This Course
Data Warehouse administrators, DBAs, data architects, DW PL/SQL developers.
Completion of our course Data Warehouse Terms, Concepts and Architecture or equivalent knowledge.
Lecture and hands-on.
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]