oracle 200x118 wht
7817  Reviews star_rate star_rate star_rate star_rate star_half

Oracle Database 19c: Data Warehousing Techniques LVC

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

Read More
$3,600 USD
Course Code D1101948GC10
Duration 3 days
Available Formats Classroom

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

  • Data warehousing concepts
  • Data warehousing techniques related to data extraction, transformation, and loading phases
  • Various data capture methods for data refresh
  • Summary management and implement materialized views
  • Role of warehouse metadata
  • Data warehouse implementation considerations

Skills Gained

  • 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