ODI 12C Developer A to Z Training

Master ODI 12C necessary skills to start building ODI processes or solutions

3.54 (211 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
ODI 12C Developer A to Z Training
854
students
8.5 hours
content
Aug 2020
last update
$44.99
regular price

What you will learn

ODI Repositories:Mater and Work

ODI 12C Components

Knowledge Modules With Example

SCD Implementation in ODI

ODI Agent and Load Plan

Procedure,Variable,Reuseable Mapping,Scenarios & Mapping

Packages in ODI

Change Data Capture(CDC) in ODI

Why take this course?

What is Oracle Data Integrator (ODI) 12C?

Oracle Data Integrator 12C (ODI) is an extract,load and transform (ELT) (in contrast with the ETL common approach) tool produced by Oracle that offers a graphical environment to build, manage and maintain data integration processes in business intelligence systems.

Oracle Data Integrator (ODI) 12c, the latest version of Oracle’s strategic Data Integration offering, provides superior developer productivity and improved user experience with a redesigned flow-based declarative user interface and deeper integration with Oracle GoldenGate. ODI12c further builds on its flexible and high-performance architecture with comprehensive big data support and added parallelism when executing data integration processes. It includes interoperability with Oracle Warehouse Builder (OWB) for a quick and simple migration for OWB customers to ODI12c. Additionally, ODI can be monitored from a single solution along with other Oracle technologies and applications through the integration with Oracle Enterprise Manager 12c.

What are we learning in the course?

  • ODI 12C Architecture and Installation Steps

  • ODI 12C Repositories

  • ODI 12C Components

  • Knowledge Modules with Examples

  • Procedures,Variables,Reusable Mapping,Scenarios and Sequence

  • ODI 12C Packages

  • SCD Implementation in ODI

  • ODI Agent and Load Plan

  • ODI Security,Profile and User Creation

Career Perspective:

If you want to pursue a career as an ETL developer,you should definitely consider taking this course.Most importantly,If you learn one ETL tool whether it's ODI 12C or Informatica,learning other ETL tools won't be difficult.Also,the demand of ETL developer is keep on increasing as the data size is increasing. 

After this Course:

Once you are done with the course,you will have maximum knowledge of ODI 12C concepts that you can implement in the industry.

Cheers..!!

Have a Great Learning..!!!

Content

Getting Started with ODI Architecture and Installation

ODI Architecture
JDK 8 Installation
Oracle Data Integrator 12C Installation
Oracle Database 12C Installation
Oracle SQL Developer

ODI Repositories

ODI Repository
Creating Master Repository
Establishing Connection and Creating Work Repository

Oracle Data Integration 12C Components

Topology:Dataserver, Physical and Logical Schema creation in ODI
Designer:Model,Datastore & Mappings in ODI
Designer:Mappings,Procedures & Packages Overview

Knowledge Modules with Examples

Oracle Data Integrator Knowledge Modules LKM & IKM
Oracle Data Integrator Knowledge Modules LKM & IKM Part-02
ODI Mapping: Loading Data from Flat File (csv) to Table
CKM with FlowControl, Static Control in mapping
JKM Journalization: CDC Simple Implementation

ODI Mapping Tranformation Components

EXPRESSION Transformation
Join Transformation,Distinct,Filter,Sort
ODI Split Component
ODI Set component
ODI Lookup Component
ODI Aggregate Component
Pivot ODI Component
Unpivot ODI Component

ODI 12C: Procedures,Variables,Reusable Mapping,Scenarios & Sequence

ODI Procedures
ODI Variables
Sequence in ODI Part-01
Sequence in ODI Part-02
Procedures with Sequence
Reuseable Mapping
Lock,Version in ODI
Scenario in ODI

ODI 12C Packages

Packages in ODI Part-01
Packages in ODI Part-02
Packages in ODI Part-03
Packages in ODI Part-04
Packages in ODI Part-05
Packages in ODI Part-06
Packages in ODI Part-07
Variables in Package Part-01
Variables in Package Part-02
Packages in ODI Part-08
Packages in ODI Part-09

Slow Changing Dimension(SCD) Implementation in ODI

Overview of Dimensional Modeling
Star Schema,Snowflake Schema and Galaxy Schema
Dimensional Modeling Design Steps
Slowly Changing Dimensions
SCD Type-01 Implementation in ODI
SCD Type-02 Implementation in ODI

ODI Agent & Load Plan

Creating Master and Work Repository with RCU
ODI Agent
Standalone Agent and J2EE Agent Configuration
How to Start Standalone Agent
Load Plan

Screenshots

ODI 12C Developer A to Z Training - Screenshot_01ODI 12C Developer A to Z Training - Screenshot_02ODI 12C Developer A to Z Training - Screenshot_03ODI 12C Developer A to Z Training - Screenshot_04

Reviews

suresh
July 10, 2023
Its very use full to beginners. if you have zero knowledge also you can get complete knowledge about this videos
Mariusz
May 8, 2023
It was quite broad approach, but some lessons were inconsistent and someteimes I felt that the author skipped some steps (for exapmle only some of the lessons have the DDL files of DB tables, that are beeing used). But overall I don't regret the money i spent on the course. It is a good introduction into the ODI.
Krishna
June 27, 2022
Organized so perfectly and it made things easy to understand. Particularly showing the log steps and willingly failing it to make it clear was a great way of explaining.
Mohammad
May 1, 2022
The beginning lesson were good and clearly explained.Towards the end the last 3sections, instructor was not clear and lessons were confusing
Abhinav
January 6, 2022
They only do it in the system but explanation wise not good , he shoul imagine that he is teaching some one and he should explain in that prospects . Expalnation not good
Altanet
December 2, 2021
In un progetto di integrazione IT&OT, mi sono occupato dell'allestimento di un database Oracle e integrazione di sistemi
Iris
March 18, 2021
He doesn't explain anything. It's just 'follow the directions' but he is selecting certain options and we have no idea why.
Jaime
February 26, 2021
Not only is this course more expensive than most, it is missing resources (scripts) in lessons, it also lacks the tutorial steps in the lectures. For the price, I expected a much higher quality course than what I'm getting. I don't know how people would be able to finish this course successfully!
Rizwanur
June 6, 2020
Trainer has given all examples in step by step approach, very good for a beginner. Same steps can be executed parallely with the video and good hands on experience will be gained.
Mohamed
June 3, 2020
J'ai apprécié cette formation ! Toutes les parties y sont abordées, de l'installation des composants jusqu'au développement des fonctionnalités. Vous aurez très certainement des bases solides pour pouvoir aborder cet outil dans un contexte professionnel.

Coupons

DateDiscountStatus
6/6/202095% OFF
expired

Charts

Price

ODI 12C Developer A to Z Training - Price chart

Rating

ODI 12C Developer A to Z Training - Ratings chart

Enrollment distribution

ODI 12C Developer A to Z Training - Distribution chart
2671588
udemy ID
11/25/2019
course created date
3/7/2020
course indexed date
Bot
course submited by