Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Oracle Data Integrator 19c - Configuration & Administration

( Duration: 3 Days )

This Oracle Data Integrator - Configuration & Administration training course provides knowledge on ODI architecture, administering and securing ODI, handling and auditing data, enforcing data quality with ODI and more.

By attending Oracle Data Integrator - Configuration & Administration workshop, delegates will learn to:

  • Administer ODI resources and setup security with ODI
  • Apply ODI Topology concepts for data integration
  • Describe ODI Model concepts
  • Describe architecture of Oracle Data Integrator 12c
  • Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations
  • Explore, audit data, and enforce data quality with ODI
  • Implement Changed Data Capture with ODI

COURSE AGENDA

1

Introduction to Integration and Administration

  • Oracle Data Integrator: Introduction
  • Oracle Data Integrator Repositories
2

Administering ODI Repositories

  • Create and connect to the Master Repository
  • Export and import the Master Repository
  • Create, connect, and set a password to the Work Repository
3

ODI Topology Concepts

  • ODI Topology: Overview
  • Data Servers and Physical Schemas
  • Defining Topology
  • Agents in Topology
  • Planning a Topology
4

Describing the Physical and Logical Architecture

  • Topology Navigator
  • Creating Physical Architecture
  • Creating Logical Architecture
5

Setting Up a New ODI Project

  • ODI Projects
  • Using Folders
  • Understanding Knowledge Modules
  • Exporting and Importing Objects
  • Using Markers
6

Oracle Data Integrator Model Concepts

  • Understanding the Relational Model
  • Understanding Reverse-Engineering
  • Creating Models
7

Organizing ODI Models and Creating ODI Datastores

  • Organizing Models
  • Creating Datastores
  • Constraints in ODI
  • Creating Keys and References
  • Creating Conditions
  • Exploring Your Data
  • Constructing Business Rules
8

ODI Mapping Concepts

  • ODI Mappings
  • Expressions, Join, Filter, Lookup, Sets, and Others
  • Behind the Rules
  • Staging Area and Execution Location
  • Understanding Knowledge Modules
  • Mappings: Overview
9

Designing Mappings

  • Multiple Sources and Joins
  • Filtering Data
  • Overview of the Flow in ODI Mapping
  • Selecting a Staging Area
  • Configuring Expressions
  • Execution Location
  • Selecting a Knowledge Module
10

Mappings: Monitoring and Troubleshooting

  • Monitoring Mappings
  • Working with Errors
11

Designing Mappings: Advanced Topics 1

  • Working with Business Rules
  • Using Variables
  • Datasets and Sets
  • Using Sequences
12

Designing Mappings: Advanced Topics 2

  • Partitioning
  • Configuring Reusable Mappings
  • Using User Functions
  • Substitution Methods
  • Modifying Knowledge Modules
13

Using ODI Procedures

  • Procedures: Overview
  • Creating a Blank Procedure
  • Adding Commands
  • Adding Options
  • Running a Procedure
14

Using ODI Packages

  • Packages: Overview
  • Executing a Package
  • Review of Package Steps
  • Model, Submodel, and Datastore Steps
  • Variable Steps
  • Controlling the Execution Path
15

Step-by-Step Debugger

  • Starting a Debug Session
  • New Functions
  • Menu Bar Icons
16

Managing ODI Scenarios

  • Scenarios
  • Managing Scenarios
  • Preparing for Deployment
17

Using Load Plans

  • What are load plans?
  • Load plan editor
  • Load plan step sequence
18

Defining restart behavior

19

Enforcing Data Quality with ODI

  • Data Quality
  • Business Rules for Data Quality
  • Enforcing Data Quality with ODI
20

Working with Changed Data Capture

  • CDC with ODI
  • CDC implementations with ODI
  • CDC implementation techniques
  • Journalizing
  • Results of CDC

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X