0703. Basic Mapping and ETL

Oracle Data Integrator (ODI) 12C All Steps Hands on

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

Requirements
Internet Access
Basic knowledge about SQL
Description
Would you like to be an 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 this course is for:
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