• Oracle Data Integrator: Data Warehousing

Oracle Data Integrator: Data Warehousing

The WebLearning Data Warehousing using Oracle Data Integrator Course provides hands-on step-by-step instructions on how to perform a variety of Data Warehousing and ETL Transformation tasks using Oracle Data Integrator in an Oracle Database environment for activities based on real-life work scenarios. 

Using the ODI graphical interfaces, you create and manage ODI repositories, which stores configuration information about the IT infrastructure, the metadata for all applications, projects, models and other ODI artifacts. You also learn how to create the ODI Topology, organize ODI models and design ODI interfaces, procedures, packages and other objects.

You will learn how to use Oracle Data Integrator Topology Manager to define context and logical schema objects according to current best practices. You will learn how to use manage projects in Oracle Data Integrator to develop interfaces and other objects.

You will learn how to create an integration process, using Oracle Data Integrator packages. This course takes you through some of the more advanced features and uses of Oracle Data Integrator interfaces. You will also learn how to use Operator to stop, start and track the execution of Oracle Data Integrator sessions.

On successful Completion of this course you will be able to:

Course Objectives for ODI 11g/12c:

  • Understand the ODI Data Warehouse and ETL Development Lifecycle
  • Understand the BI and Warehouse Development Process
  • Learn to Manage ODI 11g/12c Warehouse Projects
  • Understand Data warehousing Concepts
  • Understand Dimension Modelling
  • Understand Oracle Database warehouse Capabilities
  • Understand the Official Oracle Data warehouse Reference Architecture
  • Understand Data Quality Issues in ETL Process
  • Understand the architecture of the Oracle Data Integrator system
  • Define Data Sources
  • Define Physical and Logical Architecture
  • Create and reverse-engineer models
  • Create and Manage Projects
  • Define Integration Processes
  • Understand models, reverse-engineering model metadata from your database
  • Manage metadata in Oracle Data Integrator: models and data quality
  • Create simple interfaces and add multiple sources to an interface
  • Launch a session to run an interface
  • Enforce data quality constraints in an interface
  • Manage packages
  • Manage your ODI environment using the ODI Console

Write a review

Please login or register to review

Oracle Data Integrator: Data Warehousing

  • Brand: Weblearning Publishing
  • Product Code: Oracle Data Integrator: Data Warehousing
  • Reward Points: 100
  • Availability: In Stock
  • £89.99
  • £66.99

  • Price in reward points: 1200

  • 2 or more £59.99
  • 4 or more £49.99

Available Options


Related Products

Oracle Database SQL Workshop

Oracle Database SQL Workshop

Oracle Database SQL Workshop  This course is a combination of Oracle Database: SQL Workshop ..

£72.99 £89.99

Data Integration Unlimited

Data Integration Unlimited

Data Integration Unlimited The Data Integration Unlimited Cloud Learning Subscription is a compet..

£314.99 £348.99

Oracle Database 12/19c Essentials Certified Implementation

Oracle Database 12/19c Essentials Certified Implementation

Oracle Database 12/19c Essentials Certified Implementation The Oracle Database 12/19c Essentials ..

£169.99 £329.99

Informatica 9.6.x and Oracle Data Integrator: ETL/ELT Development

Informatica 9.6.x and Oracle Data Integrator: ETL/ELT Development

Informatica 9.6.x and Oracle Data Integrator: ETL/ELT Development The WebLearning Informatica 9.6..

£94.99 £129.99

Informatica 9.6.x Data Integration and ETL Development

Informatica 9.6.x Data Integration and ETL Development

Informatica 9.6.x: ETL/ELT Development The WebLearning Informatica 9.6.x Data Integration and ETL..

£74.99 £89.99

Oracle Data Integrator: ETL/ELT Development

Oracle Data Integrator: ETL/ELT Development

Oracle Data Integrator: ETL/ELT Development The WebLearning Informatica 9.6.x and Oracle Data Int..

£69.99 £89.99

Database Engineering Unlimited

Database Engineering Unlimited

Database Engineering Unlimited The Database Engineering Unlimited Cloud Learning Subscription is ..

£399.99 £495.00

Data Engineering Unlimited

Data Engineering Unlimited

Data Engineering Unlimited The Data Engineering Unlimited Cloud Learning Subscription is a compet..

£599.99 £675.00

Tags: Database Management, Oracle Database, SQL, DBA, ETL, Informatica, ODI, Oracle Data Integrator