Oracle Warehouse Builder 11g R2: Getting Started 2011
Bob Griesemer更新时间：2021-04-02 20:16:45
最新章节：Index封面
版权信息
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
Summary
Chapter 3. Designing the Target Structure
Data warehouse design
Data warehouse design in OWB
Summary
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
Summary
Chapter 5. Extract Transform and Load Basics
ETL
Staging
Mappings and operators in OWB
Summary
Chapter 6. ETL: Putting it Together
Designing our staging area
Review of the Mapping Editor
Creating a mapping
Summary
Chapter 7. ETL: Transformations and Other Operators
STORE mapping
PRODUCT mapping
SALES cube mapping
Features and benefits of OWB
Summary
Chapter 8. Validating Generating Deploying and Executing Objects
Validating
Generating
Deploying
Executing
Deploying and executing remaining objects
Summary
Chapter 9. Extra Features
Metadata change management
Synchronizing objects
Warehouse Builder online resources
Summary
Chapter 10. Code Template Mappings
Code templates
Connecting to SQL server using a JDBC database connection
Building a code template mapping
Summary
Index
更新时间：2021-04-02 20:16:45