3.5 out of 5
3.5
57 reviews on Udemy

Learn Data Warehouse and ODI 11g – Step by Step Guide

Find out how to create and manage Data warehouse and ETL life cycle with ODI
Instructor:
Yusuf Arslan
469 students enrolled
English [Auto-generated]
In the end of the course, you’ll design a live sample of data warehouse
Step by Step Data Warehouse Components and Structures
Implementing SCD Type-1 and SCD Type-2 Transformations in ODI
Development Jobs with using ETL and ELT logic
Using Knowledge Modules (KM) with ODI Interface
Understanding Reverse Engineering
Creating Master and Work Repository
Creating a Physical and logical Schema
Creating Model,Interface

Would you like to be a data warehouse expert with Independent
Concept Data Warehouse Training? 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 the Data Warehouse systems and its properties. In this training, all of the abilities that a Data Warehouse & Business intelligence specialist must have will be explained. In the end of the course, we’ll present a live sample of data warehouse. By using ODI (Oracle Data Integration) in the training’s content, you won’t need to do extra payment for the training of ETL tools. You’ll be able to have a wide range of informations over the topics listed bellow:

Data Warehouse

  • Data ,Entegration,Knowledge
  • Data Warehouse Definition
  • ETL/ELT Architecture
  • Incremental Load
  • Batch Load
  • Real Time Load
  • Change Data Capture
  • Real Time
  • Continuosly
  • Batch
  • Slowly Changing Dimension
  • Data Modelling
  • Conceptual Data Model
  • Logical Data Model
  • Physical Data Model
  • Fact Table
  • Dimension Table
  • Operational Database Properties and structure(OLTP)
  • Data Warehouse Schema Architecture
  • Stagingn Area Properties and structure(STG)
  • Operational Data Store Properties and structure(ODS)
  • Datawarehouse Properties and structure(DWH)
  • Datamart Properties and structure(DM)
  • Data Profiling
  • Data Quality
  • Data Cleaning
  • Metadata Management
  • End to End Data Warehouse Project Demo

ODI (Oracle Data Integrator)

  • Introduction to Oracle Data Integrator 11g
  • Introduction to oracle Data integrator
  • 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
  • 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
  • Implementing SCD Type-1 Transformations
  • Implementing SCD Type-2 Transformation
  • Creating Packages in ODI

Why you should have this course?

Because;

I’m not just talking about the concept, but with its installations, I’m moving on with examples over ODI suitable for data warehouse structure and heavily used in the sector.

Despite the course language is English, I’m providing English subtitles support in order not to miss important points.

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

As being more than 10 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.

Section 1: Introduction

1
Introduction to Course

Course Description

Section 2: Data Warehouse Fundamentals

1
Definition of a data warehouse and Properties
2
Top-Down and Bottom-up Approach
3
Defining Inmon Methodology
4
Defining Kimball Methodology
5
Overview of Extraction, Transformation, and Loading
6
Overview of Change Data Capture(CDC)
7
Understanding Slowly Changing Dimensions(SCD)
8
Data Modeling and Relational Database Design
9
OLTP(Online Transactional Processing)
10
Staging Area(STG)
11
Operational Data Store (ODS)
12
Data Warehouse Structure
13
Data Mart Concepts
14
Data Warehousing Logical Design and Schema Approches
15
Performing Data Profiling
16
Data Quality Guide
17
Describing Database Metadata

Section 3: Installation And Examples of Oracle Data Integrator (ODI)

1
Install Oracle Data Integrator(ODI) and Database Preparations

How to Install Oracle Data Integrator

2
Creating and Connecting to ODI Master Repository
3
Creating and Connecting to ODI Work Repository
4
Setting Up the Oracle Data Integrator Topology(Physical and Logical)
5
Creating and Using Data Models at ODI
6
Create a Project & Knowledge Module & Interface
7
Filter Interface
8
Join Transformation
9
Setting Up an ODI Agent

Section 4 :Live Demo

1
Creating and Using Mappings
2
Mirror Modelling
3
Data Warehouse Modelling 1
4
Data Warehouse Modelling 2
5
Data Warehouse Modelling 3
6
Data Warehouse Modelling 4

Section 5 :Documentation

1
ODI Questions and Answers
2
DWH Questions and Answers
3
10 Things that must be done while starting Datawarehouse Project
4
10 Mistakes that are commonly done in Datawarehouse Projects
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.5
3.5 out of 5
57 Ratings

Detailed Rating

Stars 5
17
Stars 4
10
Stars 3
15
Stars 2
7
Stars 1
8
3932a42099ea6275a35a31915bebbed3
30-Day Money-Back Guarantee

Includes

4 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion