更新时间:2021-04-01 13:53:02
Coverpage
Copyright Information
Credits
About the Author
About the Reviewers
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. An Introduction to Oracle Warehouse Builder
Introduction to data warehousing
Installation of the database and OWB
Summary
Chapter 2. Defining and Importing Source Data Structures
Preliminary analysis
An overview of Warehouse Builder Design Center
Importing/defining source metadata
Chapter 3. Designing the Target Structure
Data warehouse design
Data warehouse design in OWB
Chapter 4. Creating the Target Structure in OWB
Creating dimensions in OWB
Creating a cube in OWB
Using the Data Object Editor
Chapter 5. Extract Transform and Load Basics
ETL
Staging
Mappings and operators in OWB
Chapter 6. ETL: Putting it Together
Designing and building an ETL mapping
Chapter 7. ETL: Transformations and Other Operators
STORE mapping
PRODUCT mapping
SALES cube mapping
Features and benefits of OWB
Chapter 8. Validating Generating Deploying and Executing Objects
Validating
Generating
Deploying
Executing
Deploying and executing remaining objects
Chapter 9. Extra Features
Additional editing features
Warehouse Builder online resources
Index