ODI 12C All Steps - Become a ODI/ETL Developer
2.6 (20 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
583 students enrolled
Wishlisted Wishlist

Please confirm that you want to add ODI 12C All Steps - Become a ODI/ETL Developer to your Wishlist.

Add to Wishlist

ODI 12C All Steps - Become a ODI/ETL Developer

Find out how to become an Expert Data warehouse and ETL life cycle with ODI 12C
2.6 (20 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
583 students enrolled
Created by Mustafa Aksoy
Last updated 5/2016
English
Current price: $10 Original price: $120 Discount: 92% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • 20 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 100% Student Satisfaction Guarantee. How we can provide this. When you have any issue about ODI , We will be able to live session over your machine. Remember and don't hesitate to ask me any questions.In the end of the course, you’ll be able to develop and design all kind of ODI jobs(Packages, Schedules, ETL cycle, etc..)
  • Development Jobs with using ODI 12C new components, new mapping
  • Understand Knowledge Module structures
  • Create Topology and understand installation logic
  • Step by Step ODI 12C Components and Structures
  • Load Tables with different Knowledge Modul
  • Mapping Designing
View Curriculum
Requirements
  • Internet Access
  • Basic knowledge about SQL
Description

Would you like to be a ODI/ETL Developer with  ODI 12C Training? ODI 12C is a last version of Oracle's integrator tool.  In order to professionalize you at this topic, we gathered up all of the trainings and performed the application of the theorical informations to provide a better education.

After obtaining these informations, you’ll learn ODI objects/new components and design new packages/mappings. . In this training, all of the abilities that a ETL and ODI developers  must have will be explained.  You’ll be able to have a wide range of informations over the topics listed bellow:

ODI (Oracle Data Integrator) 12C

  • Introduction to Oracle Data Integrator 12C
  • ODI Studio Components
  • ODI Repositories
  • Creating Master Repository
  • Creating work Repository
  • Overview of Topology Navigator
  • Creating Physical Architecture
  • Creating a Data Server
  • Testing a Data Server Connection
  • Creating a Physical Schema
  • Creating Logical Architecture
  • New features in ODI 12C
  • using new components in ODI 12C 
  • Overview of Logical Architecture and Context Views
  • Linking the Logical and Physical Architecture
  • Understanding Metadata in ODI
  • Understanding Reverse Engineering
  • Creating Models
  • Organizing Models
  • Creating Data stores
  • Overview of ODI Projects
  • Creating a New Project
  • Introduction to Knowledge Modules
  • Types of Knowledge modules
  • Creating a Basic Interface
  • Designing an Interface
  • Integration knowledge module (IKM) overview
  • Using Knowledge Modules (KM) with ODI Interface
  • Executing the interface
  • Operator Overview
  • Viewing the session log in operator
  • Exploring the code in operator
  • Creating simple mappings
  • Setting knowledge module option Truncate to True
  • Join Transformations
  • Set Operators Transformations
  • Creating Packages in ODI

Why you should have this course?

This is not a theorical education. All of  lessons are implemented in my machine. You can find all steps that you need to know when you want to develop a project in ODI 12C. I’m moving on with examples over ODI suitable for data warehouse structure and heavily used in the real projects.

With various documents and end-of-chapter quizes, I aim to reinforce the topics.

As being more than 6 years in the sector and being an instructor in companies that have big DWH structures, I provide this course.

You are choosing an instructor that can provide support for any type of questions about the training or about DWH structures that does not fall within the training.

Who is the target audience?
  • Students
  • Developers and Analysts
  • Private company employees
  • Those who wants to develop themselves in Data Warehouse and Business Intelligence subjects
  • Data Scientists
  • Those who wants to learn ODI product and develop themselves in this subject
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 28 Lectures Collapse All 28 Lectures 05:30:05
+
Introduction
1 Lecture 01:32

About Course

Preview 01:32
+
Preparing Database Environment and ODI 12C
3 Lectures 21:29

We'll download Oracle that we need.

Downloading Oracle 12C
02:55

We'll install Oracle step by step.

Installation Oracle 12C
06:34

You can find all step in here ODI and Database.

Downloading and installation Oracle Data Integrator 12C
12:00
+
Topology &Middleware setup
2 Lectures 42:18

Installation master and work repository in ODI 12C. 

Master and Work Repository Creation
24:56

We'll create and design  Physical and Logical Schema. Everything that you will need about topology in this section.

Creating Physical/Logical Schema and Context
17:22
+
Design and Development
22 Lectures 04:24:46

We can say Interface from ODI 11g, we will see its name as Mapping.

Overview ODI Interface
19:05

Importing tables that we will use them into Mapping and Package.

Creating Model
17:22

We can start developing sample projects.

Project Interface Setup
12:17

Importing some important knowledge modules and you can meet knowledge module.

Knowledge Modul Setup
05:07

Using Joing between more then one tables and some filters.

Using Join And Filter
14:44

Hardcode data that is mean what we want to see in our target table, we need to enter manually.

Using Hardcode Data
11:44

Performing sequence in a target table.

Sequence Component in a Mapping
10:27

We have created a few mapping and we can use them into a package.

Creating a Basic Package
18:27

Using a variable in a package. Variable has a value that can be string , number or date. in this section you will learn using string and number.

Declaring a Variable
17:03

Scenario that is like a snapshot of mapping or package. 

Preview 09:29

A date variable can be used lots of projects. 

Using ETL_DATE Variable
09:49

Lookup tables has some values, they are usually description of a value. 

Lookup Tables
10:43

The components are new features in ODI 12C. And we will see using Join Component in this section.

Join Component (New Features)
11:18

Union combines more than one results. But we shouldn't forget all scripts have same column number and character types. 

Union Component (New Features)
09:08

Sorting Data over a number column using Sort component. it is new feature in ODI 12C.

Sort Component (New Features)
06:20

Distinct component is used for checking dublicate rows. it is a new feature in ODI 12C.

Distinct Component (New Features)
07:18

When we want to use "not in" or "in" or equal with other column that is in other table we can use subquery component. it is a new feature in ODI 12C.

Subquery Component (New Features)
14:27

continuing with subquery component

Using Subquery Component with different Approach
04:47

Expression component can be used for heaping some results. We will see it.

Expression Component (New Features)
14:02

Aggregate component is a new feature in ODI. we can use it for using "SUM", "COUNT" or any math formulas.

Aggregate Component (New Feature)
22:14

For seperating datas over some cases we need to use split component. This is new feature in ODI.

Split Component (New Feature)
10:02

We will see how to use a reuseble mapping. And understand why it is used.

Reusable Mapping (New Features)
08:53
About the Instructor
Mustafa Aksoy
3.0 Average rating
54 Reviews
858 Students
2 Courses
DWH Architect & Data Scientist

After graduation from university I started to work as a DWH-ETL Developer in the telecommunication company. I am a data warehousing and ETL specialist having over 5+ years of experience in telecommunication and banking Industry.

Now, I am here to share my Know-how, experience and advantages of working Data Warehouse and ETL projects with them who want to plan students' career in DWH-BI and for them who want to learn about these technologies and discover further.

good luck!