Oracle Warehouse Builder 11g: Getting Started

What you will learn from this book

• Install the most recent Oracle Database version including Warehouse Builder.
• Learn basic data warehousing concepts and analyze and design your own data warehouse.
• 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.
• Learn 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.

Approach

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.

Download link:

http://www.mediafire.com/Oracle.Warehouse.Builder.11g.Getting.Started.rar