Loading Course Schedule...
PT8633
Training Summary
This course focuses on the features within the Oracle database that support data warehouses and data mining operations. The students will learn about data warehousing concepts and the requirements to initially configure a data warehouse installation. They will also learn how the Oracle Warehouse Builder (OWB) product may be used to implement and maintain both transactional and warehouse databases, and the movement of data between those two different types of installations.
Prerequisites
The "Introduction to Data Warehouse Concepts" course should be taken or a good basic knowledge of Data Warehouses.
Duration
5 Days/Lecture & Lab
Audience
This course is designed for database administrators, data warehouse administrators and application developers who will be responsible for implementing applications using data warehouse technology
Course Topics
Data Warehouse Design & Schemas::Creating Materialized Views::Maintaining Materialized Views::Controlling the Query Rewrite Facility::Dimensions::Dimensional Analysis of Data::ETL Loading from External Tables::About the Extraction Options::ETL Transformation with Table Functions::About Oracle Warehouse Builder::Configure Oracle Warehouse Builder::Using the Design Center & Building the Infrastructure::Define Modules & Import Metadata::Data Quality Assurance & Management::Data Rules & Correction Mappings::ETL Mappings::Process Flows & Schedules