Packt is pleased to announce it latest book “Oracle Warehouse Builder 11g R2 : Getting started” which helps build a working data warehouse from scratch with Oracle Warehouse Builder. Written by Bob Griesemer, and an update to his best-selling previous edition, this book extracts, transforms and helps load data in order to build a dynamic and operational warehouse.
Oracle Warehouse Builder (OWB) 11g is a data warehousing-centered data modeling and data integration solution, built into every Oracle 11g database. OWB 11gR2 is pre-installed with Oracle Database 11gR2, and can be installed and used alongside Oracle Database 10gR2 and 11gR1.
Oracle Warehouse Builder 11g R2 : Getting started begins with the installation of the Oracle Database and Warehouse Builder software. It then moves on to the analysis of source data, designing the data warehouse, and extracting, transforming, and loading data from the source system into the data warehouse. It also includes a brand new chapter on code templates which helps in implementing complete mapping using JDBC connectivity and code template mappings.
This book will teach administrators how to configure the Oracle database in order to communicate with a non-Oracle database using Oracle Heterogeneous Services. It will also help them discover the underlying star schema relational structure that Warehouse Builder will build to implement cube and dimensions. Readers will be able to recognize what a staging area is, and build a staging table and mapping to load it from SQL Server database tables.
Filled with detailed screenshots of key steps, database engineers, administrators, and architects would find this book to be an interesting and beneficial read. This book is out now and available with Packt. For more information please visit : www.PacktPub.com/oracle-warehouse-builder-11g-r2/book.
|Oracle Warehouse Builder 11g R2: Getting Started 2011|
| Extract, Transform, and Load data to build a dynamic, operational data warehouse with Oracle Warehouse Builder 11g R2
For more information, please visit: https://www.packtpub.com/oracle-warehouse-builder-11g-r2/book