Oracle Warehouse Builder 11g R2: Getting Started 2011

This easy-to-understand tutorial covers Oracle Warehouse Builder from the ground up, and taps into the author’s wide experience as a software and database engineer. Written in a relaxed style with step-by-step explanations, lots of screenshots are provided throughout the book. There are numerous tips and helpful hints throughout that are not found in the original documentation. By following this book, you can use Oracle Warehouse Builder in the best possible way and maximize your learning potential. This book is an update of Oracle Warehouse Builder 11g: Getting Started. This book is a good starting point for database engineers, administrators, and architects who are responsible for data warehouse projects and need to design them and load data into them. If you are someone who wants to learn Oracle Warehouse Builder and expand your knowledge of the tool and data warehousing, this is an ideal book for you. No prior data warehouse or database experience is presumed. All new database and data warehouse technical terms and concepts explained in clear easy-to-understand language.

Table of Contents

Chapter 1: An Introduction to Oracle Warehouse Builder
Chapter 2: Defining and Importing Source Data Structures
Chapter 3: Designing the Target Structure
Chapter 4: Creating the Target Structure in OWB
Chapter 5: Extract, Transform, and Load Basics
Chapter 6: ETL: Putting it Together
Chapter 7: ETL: Transformations and Other Operators
Chapter 8: Validating, Generating, Deploying, and Executing Objects
Chapter 9: Extra Features
Chapter 10: Code Template Mappings