Oracle Database 19c: Data Warehousing Techniques

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Call for In Class or Live Virtual Dates2$2,700 USDPurchase


Oracle Database 19c: Data Warehousing Techniques

This course covers all facets of Data Warehousing Techniques, with lecture content and lab environment validated against the latest release of Oracle Database (19c).

Duration: 3 days

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

  • Data Warehousing Concepts
  • Data Extraction, Transformation, Loading, and Data Refresh Techniques
  • Database Sizing, Storage, and Security Consiterations
  • Summary Management and Implement Materialized Views
  • Metadata Management
  • Data Warehouse Implementation Considerations
Right Menu IconMENU