ODI 11g Hands On Tutorials

Oracle Data Integrator 11g Video Tutorials
3.3 (65 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.
723 students enrolled
$50
Take This Course
  • Lectures 82
  • Contents Video: 8.5 hours
    Other: 1.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 5/2014 English

Course Description

Overview:

  • ·Our Video courses: practical screencast-based tutorials that show you how to get the job done.
  • 3 live practice tests covers all possible questions of ODI 11g certification exam where each test consists of live 71 questions. Each video tutorial section is followed by a quiz to test your skills.
  • ·Develop the necessary skills for effectively carrying out data integration and transformations in ODI11g interfaces
  • ·Understand the use of ODI11g development objects with methods and concepts illustrated from real projects
  • ·Master the key concepts of ODI 11g’s physical and logical architecture and the use of Knowledge Modules and data models
  • ·It covers complete ODI 11g Developer & Administrator video Tutorials


What You will learn:

Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven integration processes and SOA-enabled data services. Oracle Data Integrator's Extract, Load, Transform (E-LT) architecture leverages disparate RDBMS engines to process and transform the data - the approach that optimizes performance, scalability and lowers overall solution costs.

This offering details on how to use Oracle Data Integrator (ODI) 11g to implement high-performance movement and transformation of data among various platforms. It also deals with usage of ODI 11g graphical user interfaces that enable user to access different ODI 11g components and resources that form ODI 11g infrastructure. Using the graphical interfaces, you create and manage ODI 11g repositories, which stores configuration information about the IT infrastructure, the metadata for all applications, projects, models and other ODI artifacts. You also learn how to create the ODI 11g Topology, organize ODI 11gmodels and design ODI 11g interfaces, procedures, packages and other objects.

Oracle Data Integrator (ODI) 11g is Oracle’s strategic tool covering all your data integration requirements. ODI 11g lets you write custom code easily, extract data from source files, transform data in a staging area, and load this data to your target database. So, if you are a database administrator with an aim to effectively use ODI 11g as a powerful tool for data integration solutions, it’s time you started making the most of it.


16 key Reasons to buy this course:

1. 24/7 Course Access for lifetime

2. As interactive as Classroom training

3. Very Cost effective

4. Advanced way of teaching

5. In depth explanation of each topic

6. Contains Hands on sessions

7. Any New module will be without additional charge

8. No travel and Hassel

9. Learn as per your comfort

10. Real time scenarios Hands on

11. Practice at Home using Virtual Machine

12. Free installation of ODI 11g software in your laptop

13. 100% Support will be provided to practice the Hands on's

14. More than 50 videos as on date (08-04-2014).

New videos will be added every week

15.Covers complex scenarios to aim ODI 11g certification

16. Covers most of the scenarios from ODI 11g blogs

What are the requirements?

  • Basic SQL Knowledge
  • Basic ETL knowledge

What am I going to get from this course?

  • First, you are made familiar with the basics of ETL processes and then learn how to use of ODI development objects with the help of practical examples. You then move on to get an understanding of ODI’s transformation vehicles and its interface, followed by how ODI packages can be used to develop more workflow-based data integration tasks. Next we show you how reusable objects can be customized by using variables to suit your needs. The following sections broaden your understanding of topologies, scenarios, load plans, and data integration solutions.
  • By the end of the course, you will have enough knowledge of ODI, development, deployment, and maintenance techniques to give you the confidence to develop your own data integration projects.
  • Covering all the key ODI concepts, this video course shows you how to make the best use of ODI’s declarative approach to define your strategy with Knowledge Modules.
  • This video course will show you how to use ODI for your data transformation and integration projects. It will also provide you with valuable input on which methods to use for various ODI objects according to the situation, with examples based on real-life requirements.
  • Describe ODI Model concepts
  • Describe architecture of Oracle Data Integrator 11g
  • Apply ODI Topology concepts for data integration
  • Design ODI Interfaces, Procedures, Packages, and Load Plans to perform ELT data transformations
  • Explore, audit data, and enforce data quality with ODI
  • Administer ODI resources and setup security with ODI
  • Implement Changed Data Capture with ODI

What is the target audience?

  • SOA Architect
  • Data Warehouse Administrator
  • Database Administrators
  • Data Modelers
  • Business Analysts
  • Technical Consultant
  • Beginers

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Overview of Oracle data integrator
ETL vs ELT
Preview
09:31
3 questions

Test your skills on

ETL & ELT Concepts

2 pages

After completing this module you will be able to understand

Differences between ETL approach and ELT approach

1 question

Test your skills on

ETL and ELT approaches

Introduction to Oracle Data Integrator 11g
03:51
3 questions

Test your skills on

Introduction to oracle data integrator

2 pages

After completing this module you will be able to understand you will be able to understand what is oracle data integrator

4 questions

Test your skills on

Overview of Oracle data integrator

06:23

After completing this module you will be able to understand

What is ODI Studio?

What are the 4 graphical components of ODI ?

What is Designer?

What is Operator?

What is Topology?

What is Security?

What are repositories?

What is Master Repository?

What is Work Repository

11 questions

Test you knowledge on ODI Studio Components

1 page

After completing this module you will be able to understand

What is the difference between Master Repository and Work Repository?

21 questions

Test your skills on

ODI Repositories

Optional: Overview of Oracle Data Integrator
17 pages
Section 2: Product Installation
Article

The scripts and files are used in lab environment

Please download scripts and files from downloadable materials and run the scripts with sysdba user privilize.

Flat Files and xml files can be copied to any folder.


Lecture:7 Oracle Data Integrator Developer Installation
11:44
Oracle Data Integrator Developer Installation Document
8 pages
02:14

After completing this module you will be able to understand

How to create schemas in Oracle database for ODI Repositories?

04:39

After completing this module you will be able to understand

How to create Master Repository with help of ODI Studio?

02:50

After completing this module you will be able to understand

How to create a connection to existing master repository in ODI studio?

03:12

After completing this module you will be able to understand

How to create a Work Repository using ODI Studio?

01:57

After completing this module you will be able to understand

How to attach newly created work repository to an existing master repository?

Section 3: Topology Setup
07:27

After completing this module you will be able to understand the following

Overview of Topology Navigator
Creating Physical Architecture
Creating a Data Server
Testing a Data Server Connection
Creating a Physical Schema
Creating Logical Architecture
Overview of Logical Architecture and Context Views
Linking the Logical and Physical Architecture

2 pages

After completing this module you will be able to understand

How to hide unused technologies in topology navigator?

Section 4: Models
05:37

After completing this module you will be able to understand

What is a Model?
Understanding Metadata in ODI
Understanding Reverse Engineering
Creating Models
Organizing Models
Creating Data stores

4 pages

After completing this module you will be able to understand

How to Explore Your Data

3 pages

After completing this module you will be able to understand

How to Explore Your Data

Section 5: Project and Interfaces
02:55

After completing this module you will be able to understand

Overview of ODI Projects
Creating a New Project

2 pages

After completing this module you will be able to understand

What are knowledge modules in ODI?

Article

After completing this module you will be able to understand

What are the different knowledge modules in ODI?

Optional: Knowledge Module usage
01:57
5 pages

After completing this module you will be able to understand

What to import the knowledge modules into project?

3 pages

After completing this module you will be able to understand

Business Rules for Interfaces
What is a Mapping, Filter, Join?
Overview of Integration Process

12:20

After completing this module you will be able to understand

Creating a Basic Interface
Designing an Interface
Integration knowledge module (IKM) overview
Using Knowledge Modules (KM) with ODI Interface
Setting knowledge module option Flow control to False
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

3 pages

After completing this module you will be able to understand

Monitoring Interfaces
Using Operator
Viewing Sessions and Tasks
How to Monitor Execution of an Interface
How to Troubleshoot a Session
Keys to Reviewing the Generated Code

Optional: Creating an Integration Project and Importing Knowledgemodules
06:31
Optional: Creating Simple Interface Example -1
14:11
Optional-2 Creating Simple Interface Example-2
02:53
Section 6: Filter Transformations
09:55

After completing this module you will be able understand

How to create a simple filter transformation in ODI?

Optional Creating Filter Transformation Example-1
07:43
09:18

After completing this module you will be able understand

How to create a different filter transformations in ODI?

Optional Creating Filter Transformation Example-2
09:34
07:12

After completing this module you will be able understand

How to create a Advanced filter transformation in ODI?

Optional Creating Filter Transformation Example-3
03:38
Section 7: Join Transformations
07:05

After completing this module you will be able understand

How to create a Inner Join transformation in ODI?

Optional : Join Transformation
04:37
09:00

After completing this module you will be able understand

How to create a data store by duplicating existing data store?

How to set the IKM knowledge module option Create Target table to True?

How to create a Left outer Join transformation in ODI?

04:57

After completing this module you will be able understand

How to create Right outer join transformation in ODI?

04:14

After completing this module you will be able understand

How to create Between join transformation in ODI?

03:19

After completing this module you will be able understand

How to create self join transformation in ODI?

Section 8: Set Operators Transformations
08:17

After completing this module you will be able understand

How to create Union transformation in ODI?

05:11

After completing this module you will be able understand

How to create Union All transformation in ODI?

03:53

After completing this module you will be able understand

How to create Minus transformation in ODI?

03:56

After completing this module you will be able understand

How to create Intersect transformation in ODI?

Section 9: Complex Transformations
07:42

After completing this module you will be able understand

How to create Rows to columns transformation in ODI?

07:06

After completing this module you will be able understand

How to create Columns to Rows transformation in ODI?

Section 10: Lookups Transformations
15:48

After completing this module you will be able understand

What are lookups?

How to create Left outer join Lookup transformation in ODI?

How to create Sql in from clause Lookup transformation in ODI?

Section 11: Slowly changing Dimension Transformations
27:22

After completing this module you will be able to understand

How to SCD Type-1 interface in ODI?

16:30

After completing this module you will be able to understand

How to SCD Type-2 interface in ODI?

Section 12: Aggregation Transformations
04:25

After completing this module you will be able to understand

How to handle group by in ODI?

Section 13: Yellow Interfaces in ODI
Implemernting subqueries in ODI through yellow interfaces
08:30
Section 14: Knowledge Modules
Overview of LKM and IKM knowledge Modules in ODI
19:01
Section 15: Files and XML Transformations
Exporting Delimeter Flat File to RDBMS
19:48
Exporting Fixed width Flat File to RDBMS
09:33
Exporting XML to RDBMS
14:51
Section 16: Procedures and Packages
Creating an ODI Procedure
10:29
Package Overview
1 page
Creating Packages in ODI
08:01
Section 17: Variables and Complex Package
Article

ODI variables Overview

creating loops in ODI Package (Multiple sources single target)
26:39
Section 18: Data Quality in ODI
Data Quality Introduction
Preview
17:09
Creating constraints in ODI
Preview
07:07
Creating a data quality check interfaces in ODI
25:01
Section 19: Change Data Capture
Overview and Implementation of change data capture in ODI
39:29
Section 20: ODI Run Time Components Installations
ODI Run time components overview
2 pages
ODI StandAlone Agent Installation
10 pages
ODI Standalone Agent Installation Video Part1
12:49
ODI Standalone Agent Installation Video Part2
03:40
3 questions

ODI Agents Quiz

Section 21: Scenarios & Load Plans
ODI Scenario Overview video
05:25

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Ramkumar Lanke, Certified Oracle Data Integrator Implementation Specialist

I'm an IT professional that has a passion for oracle technologies, and teaching others.

I have over 10+ years of experience with Data warehousing and Business Intelligence (primarily with Oracle technologies).

I worked in every phase of Software development life cycle including database developer and database administrator, data modelling, data integration, data analysis etc.

I am an Oracle certified Oracle Data Integrator 11g implementation specialist and handling projects in my jobs. I am regular blogger for the site www.odigurus.com and also for www.orabricks.com and write Oracle related articles.

I am also certified in Oracle Endeca Information Discovery Specialist, Oracle database 11g Data warehousing specialist, Oracle Business Intelligence Enterprise Edition 11g specialist, Oracle EBS Inventory Specialist, Oracle EBS essentials Specialist and Cloudera Hadoop Developer Specialist.

Ready to start learning?
Take This Course