Oracle Data Integrator 12c

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

Last updated 2022-01-10 | 3.8

- ODI Repositories:Mater and Work
- ODI 12C Components
- Knowledge Modules With Example

What you'll 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

* Requirements

* Basic SQL and DWH Concepts
* Tools: Oracle Database 12C
* Oracle Data Integrator 12C
* All you need a Computer machine; windows
* Mac
* and Linux users are all welcome

Description

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..!!!

Who this course is for:

  • Students who want to have a career in the field of Data warehouse/ETL developer
  • Professionals who want to learn new ETL tool to enhance their career.

Course content

9 sections • 46 lectures

ODI Architecture Preview 03:54

JDK 8 Installation Preview 05:13

Oracle Data Integrator 12C Installation Preview 09:12

Oracle Database 12C Installation Preview 08:22

Oracle SQL Developer Preview 05:21

ODI Repository Preview 05:21

Creating Master Repository Preview 09:42

Establishing Connection and Creating Work Repository Preview 19:57

Oracle Data Integrator Knowledge Modules LKM & IKM Preview 13:26

Oracle Data Integrator Knowledge Modules LKM & IKM Part-02 Preview 15:14

JKM Journalization: CDC Simple Implementation Preview 19:11

ODI Join and Set Component Example Preview 17:16

ODI Aggregate Component Preview 11:45

ODI Split Component Preview 08:29

ODI Lookup Component Preview 15:43

Pivot ODI Component Preview 11:22

Unpivot ODI Component Preview 04:41

ODI Procedure Example Preview 17:05

ODI Variables Preview 12:10

Sequence in ODI Part-01 Preview 18:09

JSON File Processing with Sequences Preview 19:58

Procedure with Sequence Preview 08:29

Reuseable Mapping in ODI Preview 08:18

Lock,Version in ODI Preview 07:05

Scenarios in ODI 12C Preview 05:44

Package in ODI Part-01 Preview 12:29

Package in ODI Part-02 Preview 09:50

Package in ODI Part-03 Preview 09:08

Packages in ODI Part-04 Preview 10:32

Packages in ODI Part-05 Preview 11:58

Packages in ODI Part-06 Preview 09:48

Package in ODI Part-07 Preview 07:36

Variables in Package Part-01 Preview 11:09

Variables in Package Part-02 Preview 13:11

Overview of Dimensional Modeling Preview 11:40

Star Schema,Snowflake Schema and Galaxy Schema Preview 03:25

Dimensional Modeling Design Steps Preview 12:34

Slowly Changing Dimensions Preview 09:22

SCD Type-01 Implementation in ODI Preview 06:01

SCD Type-02 Implementation in ODI Preview 10:02

Creating Master and Work Repository with RCU Preview 11:40

Standalone Agent and J2EE Agent Configuration Preview 10:09

How to Start Standalone Agent Preview 03:49

Load Plan Preview 19:19