Oracle Warehouse Builder 11g R2: Getting Started 2011

Extract, Transform, and Load data to build a dynamic, operational data warehouse

Key Features

• Build a working data warehouse from scratch with Oracle Warehouse Builder
• Cover techniques in Extracting, Transforming, and Loading data into your data warehouse
• Use a multi-dimensional design with an underlying relational star schema
• This second edition covers great new features of 11gR2 such as the new user interface and a whole new chapter on code templates that implement knowledge module functionality from Oracle Data Integrator

Book Description

What you will learn

• Configure your Oracle database to communicate with a non-Oracle database using Oracle Heterogeneous Services
• Build, view, and edit a cube and its dimensions, using Warehouse Builder Wizards and the Data Object Editor
• Discover the underlying star schema relational structure that Warehouse Builder will build to implement your cube and dimensions
• Recognize what a staging area is, and build a staging table and mapping to load it from SQL Server database tables
• Master various operators for use in mappings, for the transformation and flow of data
• Build and execute mappings to load dimensions and a cube using the Warehouse Builder Mapping Editor and Control Center Manager
• Detailed explanation of the new interface in 11gR2
• Implement JDBC connectivity to a remote database and access source data using a code template mapping

Who this book is for

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.