oracle 200x118 wht

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
6119 Reviews star_rate star_rate star_rate star_rate star_half
Course Image

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
Contact Us 1-800-803-3948
Contact Us
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward