• 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.x and Oracle Data Integrator: Data Integration and ELT/ETL Development Course provides hands-on step-by-step instructions on how to perform a variety of Data Integration and ETL Transformation tasks using Informatica and Oracle Data Integrator in an Oracle Database environment for activities based on real-life work scenarios. This course combines the WebLearning Oracle Data Integrator 11g: ELT/ETL Development and the WebLearning Informatica ETL Development courses.

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.

Using the Informatica ETL Tools, Informatica PowerCenter developers and administrators will learn about the Informatica 9.x architecture, introduce you to working with the PowerCenter Designer, Workflow Manager, and Workflow Monitor tools, performing tasks such as creating transformations, mappings, reusable objects, sessions and workflows to extract, transform and load data. 

You will develop cleansing, formatting, sorting and aggregating procedures. You can learn how to use routers, update strategies, parameters /variables and overrides. This course will cover many different types of lookups, such as cached, persistent, dynamic and multiple row returns. Workflow tasks will be created to define a set of instructions for executing the ETL.

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.

Using the Informatica ETL Tools, Informatica PowerCenter developers and administrators will learn about the Informatica 9.x architecture, introduce you to working with the PowerCenter Designer, Workflow Manager, and Workflow Monitor tools, performing tasks such as creating transformations, mappings, reusable objects, sessions and workflows to extract, transform and load data. You will develop cleansing, formatting, sorting and aggregating procedures.


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

Course Objectives for ODI 11g/12c:

  • Learn to Plan and Scope your ETL/ELT Projects
  • Understand the ETL Development Lifecycle
  • Understand basic Data warehousing Concepts
  • Understand basic Dimension Modelling
  • 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
  • Manage Projects
  • Define Integration Processes
  • Work with projects in Oracle Data Integrator
  • Release your ODI work for deployment
  • 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 and Monitor ETL processes in the ODI Console

Course Objectives for Informatica 9.6.x:

  • Learn to Plan and Scope your ETL/ELT Projects
  • Understand the ETL Development Lifecycle
  • Understand basic Data warehousing Concepts
  • Understand basic Dimension Modelling
  • Understand Data Quality Issues in ETL Process
  • Understand the architecture of the complete Informatica system
  • Design and build simple mappings and workflows
  • Use PowerCenter 9.x Designer to build mappings that extract data from a source to a target
  • Use PowerCenter 9.x Designer to build transformations
  • Use PowerCenter transformations to cleanse, format and join data
  • Use PowerCenter transformations to aggregate and route data to targets
  • Perform error handling/trapping using PowerCenter mappings
  • Describe the use of Mapping Variables and Parameter Files
  • Use PowerCenter 9.x Workflow Manager to build and run a workflow
  • Use PowerCenter 9.x Workflow Manager to execute sessions associated with a mapping
  • Perform basic troubleshooting using PowerCenter logs and debugger

Write a review

Please login or register to review

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

  • Brand: Weblearning Publishing
  • Product Code: Informatica 9.6.x & Oracle Data Integrator: Bundle
  • Reward Points: 600
  • Availability: In Stock
  • £129.99
  • £94.99


  • 2 or more £89.99
  • 4 or more £79.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

Oracle Database Design and Programming with SQL CBT

Oracle Database Design and Programming with SQL CBT

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£59.99 £79.99

Oracle Database Design and Programming with SQL eLearning

Oracle Database Design and Programming with SQL eLearning

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£59.99 £79.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: Data Warehousing

Informatica 9.6.x and Oracle Data Integrator: Data Warehousing

Informatica 9.6.x and Oracle Data Integrator: Data Warehousing The WebLearning Data Warehousing u..

£96.99 £139.99

Informatica 9.6.x: Data Warehousing

Informatica 9.6.x: Data Warehousing

Informatica 9.6.x: Data Warehousing The WebLearning Data Warehousing using Informatica 9.6.x cour..

£76.99 £99.99

Oracle Data Integrator: Data Warehousing

Oracle Data Integrator: Data Warehousing

Oracle Data Integrator: Data Warehousing The WebLearning Data Warehousing using Oracle Data Integ..

£66.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