Learn Data Warehouse and ODI 11g - Step by Step Guide (2015)

WEBRip | MP4/AVC, ~517 kb/s | 1350 x 720 | English: AAC, 62.0 kb/s (2 ch), 44.1 KHz | 1.03 GB

Genre: IT & Software / IT Certification | Language: English | +Project Files

Find out how to create and manage Data warehouse and ETL life cycle with ODI

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.