Durată: 3 zile
Certificare: Diploma de participare
Data Analyst, Data Architect, Database Administrator
-
This course covers all facets of Data Warehousing Techniques, with lecture content and lab environment validated against the latest release of Oracle Database (19c).
The course covers the following topics:
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.
You will learn how to:
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