ISBN 10:
0-9797951-7-6
ISBN 13:
978-0-9797951-7-6 |
Library of Congress Number: TBD |
|
480 pages: Hardcover - 9x7
|
Publication
Date:
TBD |
|
Shelving: Database/Oracle |
Easy Oracle Series # 7 |
|
|
Easy Oracle Warehouse Builder
Designing a Robust Oracle Data Warehouse
with OWB
TBD
Retail Price $69.95
/ £47.95
| Order now and
get immediate online access to the
code depot! |
Only $51.95
(30% off) |
|
|
|
Oracle’s Warehouse Builder is a powerful tool for Business
Intelligence professionals, whether you are a developer,
database administrator, or business analyst. From start to
finish, Warehouse Builder can help you manage the design and
deployment of not only database objects, but also your entire
ETL process. Additionally, Warehouse Builder offers you the
ability to sample, profile, and transform your data.
Many companies manage the design and deployment of
warehouse-based applications the old fashioned way: a series of
scripts scattered throughout the enterprise, scheduled jobs
being managed by several agents, and trying to keep production,
development, and QA databases in sync. Warehouse Builder offers
you a means of managing these - and many more – activities.
In Easy Oracle Warehouse Builder, you’ll
be introduced to many of Warehouse Builder’s tools and features,
and will be guided through a step-by-step example of designing,
deploying, and managing a warehouse from scratch.
|
* Learn expert techniques for
creating ETL jobstreams.
* See how to optimize your data warehouse architecture for optimal
performance.
* Understand how to use partitioning for maximum benefit.
* See how to leverage external tables in an Oracle data
warehouse.
* Understand fact table and dimension management.
* See how to build mappings and process flows on OWB.
|
About the Author:
Table of Contents:
Chapter 1: Introduction
Intended audience
Chapter 2: Data Warehouse Basics
Types of databases
Relational versus dimensional modeling
Facts, dimensions and cubes
Chapter 3: ETL Overview
Tools in Oracle used for ETL
SQL*Loader
External tables
Datapump export/import
SQL operations
Chapter 4: Partitioned Tables and Indexes
Types of partitioning
Managing partitioning
Parallel execution operations (parallel query and parallel DML)
Tips and techniques
Chapter 5: Overview of Warehouse Builder
How OWB fits into Oracle’s Business Intelligence road map
Core features
Optional features and licensing
Chapter 6: Warehouse Builder Architecture
Design/implementation considerations
Oracle 10g versus 11g
Chapter 7: Warehouse Builder Administration
Installing, patching and migrating Warehouse Builder
Security
Understanding users, roles, sources, targets and workspaces
Chapter 8: Introduction to the Case Study
Business description
Business requirements
Flow of data via the ETL process
Chapter 9: Files
Building Files
Gathering file metadata
Chapter 10: External Tables
External tables in Oracle
Building external tables via Warehouse Builder
Manually creating external tables
Chapter 11: Tables
Ways to build tables
Using the Design Object Editor
Chapter 12: Dimensions and Cubes
Building Dimensions and Cubes |
Chapter 13: Mappings
Building a process map
Chapter 14: Process Flow
Building a process flow
Overview of Oracle Workflow Manager
Chapter 15: Schedules
Oracle jobs and schedules
Creating a schedule
Assigning a schedule
Chapter 16: Putting it All Together
Where we are so far
Executing the ETL process via Warehouse Builder
Chapter 17: Transforming Data
Data rules (fixing data before loading)
Data transformations (altering data after loading)
Functions, procedures, and packages
Chapter 18: Expanding the Case Study
Expanding the ETL process
From flat file to loaded table
Chapter 19: Data Quality
Data management
Why data quality matters
Chapter 19: Profiling Data
Using the Data Profiler
Interpreting profiler results
Chapter 20: Deployments
Deploying the metadata/design into production
Promoting changes both ways
Chapter 21: Public Objects
Transformations
Experts
User defined modules
Public data rules
Icon sets
Chapter 22: Locations and Control Centers
Understanding locations
Using multiple control centers
Chapter 23: Other Warehouse Builder Tools
Repository Browser
OMB+
MDL files
Importing and exporting mdl files
Snapshots
Metadata Dependency Manager (Lineage and Impact Analysis)
Chapter 24: Data Warehousing Resources
Data Warehouse Institute
Object Management Group and the Common Warehouse Metamodel™
Oracle by Example
Books
|
|
|
Index Topics:
Reviews:
Errata:
|
