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

Information of news
26-12-2015, 01:28

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

Category: Tutorials / Other

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

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
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?
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.

What are the requirements?

Internet access

What am I going to get from this course?

Over 37 lectures and 4 hours of content!
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

What is the target audience?

Private company employees
Those who wants to develop themselves in Data Warehouse and Business Intelligence subjects
Data Scientists
Database Managers
Those who wants to learn ODI product and develop themselves in this subject

Section 1: Section 1: Introduction
Lecture 1 Introduction to Course 02:01
Course Description

Section 2: Section 2: Data Warehouse Fundamentals
Lecture 2 Definition of a data warehouse and Properties 02:44
Lecture 3 Top-Down and Bottom-up Approach 02:00
Lecture 4 Defining Inmon Methodology 05:09
Lecture 5 Defining Kimball Methodology 01:48
Lecture 6 Overview of Extraction, Transformation, and Loading 02:47
Lecture 7 Overview of Change Data Capture(CDC) 09:37
Lecture 8 Understanding Slowly Changing Dimensions(SCD) 04:04
Lecture 9 Data Modeling and Relational Database Design 08:01
Lecture 10 OLTP(Online Transactional Processing) 02:27
Lecture 11 Staging Area(STG) 06:11
Lecture 12 Operational Data Store (ODS) 01:59
Lecture 13 Data Warehouse Structure 02:25
Lecture 14 Data Mart Concepts 03:29
Lecture 15 Data Warehousing Logical Design and Schema Approches 05:14
Lecture 16 Performing Data Profiling 01:10
Lecture 17 Data Quality Guide 12:15
Lecture 18 Describing Database Metadata 02:17
Section 3: Section 3: Installation And Examples of Oracle Data Integrator (ODI)
Lecture 19 Install Oracle Data Integrator(ODI) and Database Preparations 07:21
How to Install Oracle Data Integrator
Lecture 20 Creating and Connecting to ODI Master Repository 04:41
Lecture 21 Creating and Connecting to ODI Work Repository 02:50
Lecture 22 Setting Up the Oracle Data Integrator Topology(Physical and Logical) 03:18
Lecture 23 Creating and Using Data Models at ODI 01:39
Lecture 24 Create a Project & Knowledge Module & Interface 07:45
Lecture 25 Filter Interface 02:59
Lecture 26 Join Transformation 04:31
Lecture 27 Setting Up an ODI Agent 06:52
Section 4: Section 4 :Live Demo
Lecture 28 Creating and Using Mappings 14:07
Lecture 29 Mirror Modelling 19:19
Lecture 30 Data Warehouse Modelling 1 17:25
Lecture 31 Data Warehouse Modelling 2 17:06
Lecture 32 Data Warehouse Modelling 3 19:23
Lecture 33 Data Warehouse Modelling 4 19:23
Section 5: Section 5 :Documentation
Lecture 34 ODI Questions and Answers 5 pages
Lecture 35 DWH Questions and Answers 4 pages
Lecture 36 10 Things that must be done while starting Datawarehouse Project 1 page
Lecture 37 10 Mistakes that are commonly done in Datawarehouse Projects 1 page








Site BBcode/HTML Code:
Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.

Tag Cloud

archive of news

free html hit counter