D64054 - Data Integration and ETL with Oracle Warehouse Builder: Part 2

Participants learn to use Warehouse Builder to define both relational dimensional models and multidimensional models, deploy a single logical model to multiple physical targets using multiple named configurations and how to handle slowly changing dimensions.

Extraction of data from non-Oracle sources using code templates, usage of the Warehouse Builder ETL and data integration features of the Enterprise ETL Option of the Oracle database are discussed. Participants also use Warehouse Builder to define both relational dimensional models and multidimensional models.

This functionality requires the Oracle Warehouse Builder Enterprise ETL/ODI EE option.

Learn To:

  • Use Warehouse Builder to define both relational dimensional models and multidimensional models
  • Deploy a single logical model to multiple physical targets using multiple named configurations
  • Handle slowly changing dimensions
  • Extract data from non-Oracle sources using code templates
  • Use the Warehouse Builder ETL and data integration features of the Enterprise ETL Option of the Oracle database
  • Use Warehouse Builder to define both relational dimensional models and multidimensional models

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Duration:

Enquire Now

Start learning today!

Click Hereto customize your Training

Objectives

Upon completing this course, the learner will be able to meet these overall objectives:
  • Define relational dimensional and multidimensional models
  • Deploy a logical model to multiple physical configurations
  • Create and manage a type 2 slowly changing dimension
  • Utilize the Warehouse Builder ETL and data integration features of the Enterprise ETL Option of the Oracle database
  • Create near-realtime and trickle-feed mappings
  • Use code templates in mappings to extract data from non-Oracle sources

Content

Module 1: Administrative Tasks in Warehouse Builder
Module 2: Managing Metadata
Module 3: Accessing Non-Oracle Sources
Module 4: Designing Mappings with the Oracle Data Integration Enterprise Edition License
Module 5: Right-Time Data Warehousing with OWB
Module 6: Defining Relational Models
Module 7: More Relational Dimensional Modeling
Module 8: Modeling Multidimensional OLAP Dimensions and Cubes
Module 9: Appendix: Configuring Warehouse Builder in RAC Environments
Module 10: Appendix: Service-Oriented Architectures
Module 11: Appendix: Importing COBOL Copybooks

Audience

  • Developer
  • Support Engineer
  • Data Warehouse Analyst
  • Business Intelligence Developer
  • Data Warehouse Developer
  • Data Warehouse Administrator

Prerequisites

  • Experience in basic use of Oracle RDBMS, including SQL DDL and DML, and PL/SQL

Suggested Prerequisites:

  • Oracle BI Warehouse Builder 11g R2: Getting Started (OBE)
  • Introduction to Business Intelligence Products (eStudy)
  • Oracle Database 11g: Data Warehousing Fundamentals

Certification

product-certification

This course is not associated with any Certification.

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Oracle Popular Courses

d90871

This training is the first step in mastering MySQL, the world’s most popular open source database.

p10380

P10380 - Oracle Database 18c: Administration Workshop

d79995

Learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code.

d83527

D83527 - Java SE 8 Fundamentals
Enquire Now
nNAFO5
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy