The Oracle Database 19c: Data Warehousing Techniques course teaches you the various Data Warehousing concepts and techniques related to data extraction, transformation, and loading phases. You will learn about the different changed data capture methods for data refresh, and how to define summary management and implement materialized views. You will also learn about the role of warehouse metadata along with the various data warehouse implementation considerations.
The course covers the following topics:
Objectives
- Connect to ODI Master and Work Repositories
- Define the Topology for source and target data warehouse system
- Set Up an ODI Project
- Create ODI Models and Reverse Engineer
- Check Data Quality in the Model
- Create an ODI Mapping: Simple Transformations
- Create an ODI Mapping: Complex Transformations
- Load Data from a Single Data Source
- Load Data from Multiple Data Sources
Topics
- Course Overview
- Data Extraction Techniques
- Introduction to Data Transformation
- Data Transformation Techniques
- Data Loading Techniques
- Database Sizing, Storage, and Security Considerations
- Data Refresh Techniques
- Summary Management
- Metadata Management
- Data Warehouse Implementation Considerations
Other Trainings
Database
65 Training Set
