ERP Products Other Products Virtual Classroom


paypal verified
paypal cartes de crédit

Data Integration and ETL with Oracle Warehouse Builder: Part 2 New

Data Integration and ETL with Oracle Warehouse Builder: Part 2 New

Now you can study at home by your self and
get certified.

These set teach you everything you need to know to become an Oracle Certified Professional.

The tests are based directly from the information from these books

Data Integration and ETL with Oracle Warehouse Builder: Part 2

What you will learn

introduces students to the array of options that extend the functionality of OWB.
Students learn the extended ETL and data integration functionality available in the Enterprise ETL/ODI EE option.

Learn to:

Use Warehouse Builder to define both relational dimensional models and multidimensional models.
Deploy a single logical model to multiple physical targets using multiple named configurations.
Handle slowly changing dimensions.
Extract data from non-Oracle sources using code templates.
Use the Warehouse Builder ETL and data integration features of the Enterprise ETL Option of the Oracle database.

Course Objectives

Define relational dimensional and multidimensional models
Deploy a logical model to multiple physical configurations
Create and manage a type 2 slowly changing dimension
Use code templates in mappings to extract data from non-Oracle sources
Utilize the Warehouse Builder ETL and data integration features of the Enterprise ETL Option of the Oracle database
Create near-realtime and trickle-feed mappings

Administrative Tasks in Warehouse Builder
Enterprise ETL License Extends Core In-Database ETL
Multiple Named Configurations: Why and How
Using Multiple Named Configurations
Using Configuration Templates
Steps for Setting Up OWB in a RAC Environment
Creating an OWB Schedule
Managing Metadata
Using Lineage and Impact Analysis Diagrams
Invoking Lineage and Impact Analysis
Using the Change Propagation Dialog
User-Defined Properties, Icons, and Objects
Using Pluggable Mappings
Advanced Activity Types in Process Flows
Native Relational Object Support
Heterogeneous Predefined SQL Transformations
Accessing Non-Oracle Sources
Extensible Framework of OWB 11g Release 2
Benefits of Extensible Code Templates
Location of Seeded Code Templates
Creating New Code Templates
Defining New Integration Platforms in OWB
Designing Mappings with the Oracle Data Integration Enterprise Edition License
Traditional Versus Code Template (CT) Mappings
Execution Units in a CT Mapping
Execution View Versus Logical View
Assigning a Code Template to an Execution Unit
Convert a Classic Mapping to a CT Mapping That Utilizes Data Pump
CT Mappings Deploy to Control Center Agents
Right-Time Data Warehousing with OWB
What Is Meant by Real-Time Data Warehousing
What Refresh Frequency Does OWB Support
Building a Trickle Feed Mapping
Using Advanced Queues in Trickle Feed Mappings
Using CDC Code Templates in Mappings for Change Data Capture
Starting CDC Capture Process
Defining Relational Models
Defining Dimensions Using Wizards and Editors
Defining Dimension Attributes, Levels, and Hierarchies
Binding Dimension Attributes to the Implementation Table
Using the Create Time Dimension Wizard
Defining a Cube
Specifying a Cube's Attributes and Measures
Designing Mappings Using Relational Dimensions and Cubes

More Relational Dimensional Modeling
Initial Versus Incremental Data Warehouse Loads
Updating Data and Metadata
Capturing Changed Data for Refresh
Setting Loading Properties
Choosing the DML Load Type
How OWB Manages Orphans
Support for Cube-Organized Materialized Views
Creating a Type 2 Slowly Changing Dimension
Modeling Multidimensional OLAP Dimensions and Cubes
What Is OLAP
Multidimensional Data Types
Analytic Workspace
Dimensional Modeling Using OWB
OWB Calculated Measures
Differences Between OLAP and Relational Loading
Appendix: Configuring Warehouse Builder in RAC Environments
Oracle Real Application Clusters (RAC)
Control Center Service Failover on RAC
Installing OWB on Real Application Clusters
Useful Diagnostics for OWB RAC Problems
Appendix: Service-Oriented Architectures
What Are Services
Publishing a Web Service
Methods for Creating a Mapping That Uses Web Services
Consuming a Web Service
Accessing Web Services Securely
Appendix: Importing COBOL Copybooks
Flexible File Import Options in OWB 11g Release 2
Enhanced Support for COBOL Copybook Import
Selecting Copybooks to Import
Examine Advanced Import Session Options


Shipping is free IMMEDIATE DOWNLOAD AFTER PAYMENT .Receive a direct download link in your email in 1 - 3 minutes.

[Do NOT forget to check the junk or Spam mails of your email box]

29.99 $

Enter promotionnal code:

Terms & Policy

Website hosting and design by       admin