更新时间：2021-04-02 20:16:45
封面
版权信息
Credits
About the Author
About the Reviewers
www.PacktPub.com
Support files eBooks discount offers and more
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 database object 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
The Product dimension
The Store dimension
Creating a cube in OWB
Using the data object editors
Chapter 5. Extract Transform and Load Basics
ETL
Staging
Mappings and operators in OWB
Chapter 6. ETL: Putting it Together
Designing our staging area
Review of the Mapping Editor
Creating a 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
Metadata change management
Synchronizing objects
Warehouse Builder online resources
Chapter 10. Code Template Mappings
Code templates
Connecting to SQL server using a JDBC database connection
Building a code template mapping
Index
