Oracle Warehouse Builder 11g R2: Getting Started 2011


Oracle Warehouse Builder 11g R2: Getting Started 2011
eBook: $32.99
Formats: PDF, PacktLib, ePub and Mobi formats
$28.04
save 15%!
Print + free eBook + free PacktLib access to the book: $87.98    Print cover: $54.99
$54.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • 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 Details

Language : English
Paperback : 424 pages [ 235mm x 191mm ]
Release Date : May 2011
ISBN : 1849683441
ISBN 13 : 9781849683449
Author(s) : Bob Griesemer
Topics and Technologies : All Books, Enterprise Products and Platforms, Oracle Database, Enterprise, Oracle

Table of Contents

Preface
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
Index
  • Chapter 1: An Introduction to Oracle Warehouse Builder
    • Introduction to data warehousing
      • Introduction to our fictional organization
      • What is a data warehouse?
      • Where does OWB fit in?
    • Installation of the database and OWB
      • Downloading the Oracle software
      • A word about hardware and operating systems
      • Installing Oracle database software
      • Configuring the listener
      • Creating the database
      • Installing the OWB standalone software
      • OWB components and architecture
      • Configuring the repository and workspaces
    • Summary
    • Chapter 2: Defining and Importing Source Data Structures
      • Preliminary analysis
        • ACME Toys and Gizmos source data
        • The POS transactional source database
        • The website order management database
      • An overview of Warehouse Builder Design Center
      • Importing/defining source database object metadata
        • Creating a project
        • Creating a module
          • Creating an Oracle Database module
          • Creating a SQL Server database module
        • Importing source database objects from a database
        • Defining source metadata manually with the Table Editor
        • Importing source metadata from files
      • Summary
      • Chapter 3: Designing the Target Structure
        • Data warehouse design
          • Dimensional design
            • Cube and dimensions
          • Implementation of a dimensional model in a database
            • Relational implementation (star schema)
            • Multidimensional implementation (OLAP)
          • Designing the ACME data warehouse
            • Identifying the dimensions
            • Designing the cube
        • Data warehouse design in OWB
          • Creating a target user and module
            • Creating a target user
            • Create a target module
          • OWB design objects
        • Summary
        • Chapter 4: Creating the Target Structure in OWB
          • Creating dimensions in OWB
            • The Time dimension
              • Creating a Time dimension with the Time Dimension Wizard
            • The Product dimension
              • Product attributes (attribute type)
              • Product levels
              • Product hierarchy (highest to lowest)
              • Creating the Product dimension with the new Dimension Wizard
            • The Store dimension
              • Store attributes (attribute type), data type and size, and (Identifier)
              • Store levels
              • Store hierarchy (highest to lowest)
              • Creating the Store dimension with the New Dimension Wizard
          • Creating a cube in OWB
            • Creating a cube with the wizard
          • Using the data object editors
          • Summary
          • Chapter 5: Extract, Transform, and Load Basics
            • ETL
              • Manual ETL processes
            • Staging
              • To stage or not to stage
              • Configuration of a staging area
            • Mappings and operators in OWB
              • OWB Mappings
                • The canvas layout
              • OWB operators
                • Source and target operators
                • Transformations (data flow operators)
                • Other operators
            • Summary
            • Chapter 6: ETL: Putting it Together
              • Designing our staging area
                • Designing the staging area contents
                • Building the staging area table with the Table Editor
              • Review of the Mapping Editor
              • Creating a mapping
                • Adding source tables
                • Adding a target table
                • Connecting source to target
                  • Joiner operator attribute groups
                  • Connecting operators to the Joiner
                  • Defining operator properties for the JOINER
                  • Adding an Aggregator operator
              • Summary
              • Chapter 7: ETL: Transformations and Other Operators
                • STORE mapping
                  • Adding source and target operators
                  • Adding Transformation Operators
                  • Using a Lookup operator
                    • Creating an external table
                    • Creating and loading a lookup table
                    • Retrieving the key to use for a Lookup operator
                    • Adding a SUBSTR Transformation operator
                    • Adding a Constant operator
                    • Adding a TO_NUMBER transformation
                    • Adding a Lookup operator
                • PRODUCT mapping
                • SALES cube mapping
                  • Dimension attributes in the cube
                  • Measures and other attributes in the cube
                  • Mapping values to cube attributes
                    • Mapping measures' values to a cube
                    • Mapping PRODUCT and STORE dimension values to the cube
                    • Mapping DATE_DIM values to the cube
                    • Mapping an Expression operator
                • Features and benefits of OWB
                • Summary
                • Chapter 8: Validating, Generating, Deploying, and Executing Objects
                  • Validating
                    • Validating in the Design Center
                    • Validating using the toolbar icon in the Mapping Editor
                  • Generating
                    • Generating in the Design Center
                    • Generating using the icon from the mapping editor
                    • Default operating mode of the mapping
                    • Selecting the generation style
                  • Deploying
                    • The Control Center Service
                    • Deploying in the Design Center and Data Object Editor
                    • The Control Center Manager
                      • The Control Center Manager window overview
                      • Deploying in the Control Center Manager
                  • Executing
                  • Deploying and executing remaining objects
                    • Deployment order
                    • Execution order
                  • Summary
                  • Chapter 9: Extra Features
                    • Metadata change management
                      • Metadata Loader (MDL) exports and imports
                      • Recycle bin
                      • Cut, copy, and paste
                      • Snapshots
                    • Synchronizing objects
                      • Changes to tables
                        • Updating object definitions
                        • Synchronizing
                      • Changes to dimensional objects and binding
                    • Warehouse Builder online resources
                    • Summary
                    • Chapter 10: Code Template Mappings
                      • Code templates
                        • Code template description
                        • Types of code templates
                        • Pre-defined code templates
                      • Connecting to SQL server using a JDBC database connection
                        • Downloading the JDBC driver
                        • Creating a SQL server module
                          • Configuring SQL server TCP/IP port
                          • Creating SQL server module
                          • Importing metadata
                      • Building a code template mapping
                        • Starting the Control Center Agent
                        • Defining a template mapping module
                        • Creating a code template mapping
                          • Copying a mapping
                          • Editing a code template mapping
                        • Deploying and executing a code template mapping
                      • Summary

                      Bob Griesemer

                      Bob Griesemer has over 27 years of software and database engineering/DBA experience in both government and industry, solving database problems, designing and loading data warehouses, developing code, leading teams of developers, and satisfying customers. He has been working in various roles involving database development and administration with the Oracle Database with every release since Version 6 of the database from 1993 to the present. He has also been performing various tasks, including data warehouse design and implementation, administration, backup and recovery, development of Perl code for web-based database access, writing Java code utilizing JDBC, migrating legacy databases to Oracle, and developing Developer/2000 Oracle Forms applications. He is currently an Oracle Database Administrator Certified Associate, and is employed by the Northrop Grumman Corporation, where he is currently a Senior Database Analyst on a large data warehouse project.
                      Sorry, we don't have any reviews for this title yet.

                      Code Downloads

                      Download the code and support files for this book.


                      Submit Errata

                      Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.


                      Errata

                      - 4 submitted: last submission 09 May 2013

                      Page 23 | Errata type: Typo

                      In the notes section on this page, the note should start with "The" and not "Te".

                      Page 37 | Errata type: Typo

                      In the following line, role has been wrongly written as roll:
                      "An additional step will be required to specify another user who has the ability to do that assignment (grant that roll) or has DBA privileges."
                      Should be
                      "An additional step will be required to specify another user who has the ability to do that assignment (grant that role) or has DBA privileges.

                      Page 78 | Errata type: Typo

                      In the first paragraph, "We are now at the point where we can finally import our source database objects. source database objects.
                      Should be:
                      In the first paragraph, "We are now at the point where we can finally import our source database objects.
                      "source database objects." is repeated unnecessarily.

                      Page 64 | Errata type: Language

                      In Paragraph 3
                      "The generic connectivity agent is limited in some of the features it allows when accessing another non-Oracle databases compared to the gateways, and this factor may depend on whether we need these features or not."
                      Should read:
                      "The generic connectivity agent is limited in some of the features it allows when accessing other non-Oracle databases compared to the gateways, and this factor may depend on whether we need these features or not."

                      Sample chapters

                      You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                      Frequently bought together

                      Oracle Warehouse Builder 11g R2: Getting Started 2011 +    Oracle Application Integration Architecture (AIA) Foundation Pack 11gR1: Essentials =
                      50% Off
                      the second eBook
                      Price for both: $49.65

                      Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                      What you will learn from this book

                      • 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

                      In Detail

                      In today's economy, businesses and IT professionals cannot afford to lag behind the latest technologies. Data warehousing is a critical area to the success of many enterprises, and Oracle Warehouse Builder is a powerful tool for building data warehouses. It comes free with the latest version of the Oracle database.

                      Written in an accessible, informative, and focused manner, this book will teach you to use Oracle Warehouse Builder to build your data warehouse. Covering warehouse design, the import of source data, the ETL cycle and more, this book will have you up and running in next to no time.

                      This book will walk you through the complete process of planning, building, and deploying a data warehouse using Oracle Warehouse Builder. By the book's end, you will have built your own data warehouse from scratch.

                      Starting with the installation of the Oracle Database and Warehouse Builder software, this book then covers the analysis of source data, designing a data warehouse, and extracting, transforming, and loading data from the source system into the data warehouse. You'll follow the whole process with detailed screenshots of key steps along the way that have all been updated for the new Fusion Client Platform interface in 11gR2, alongside numerous tips and hints not covered by the official documentation.

                      You’ll finish up with a brand new chapter on code templates where you’ll implement a complete mapping using JDBC connectivity and code template mappings.

                      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.

                      This book is an update of Oracle Warehouse Builder 11g: Getting Started.

                       

                      Podcast content courtesy of Oracle

                      Join an interview with the book's author Bob Griesemer and Dain Hansen (Director of Product Marketing for Oracle Fusion Middleware) to hear about new trends in data integration and how Oracle Warehouse Builder 11g especially can help customers improve efficiencies for building and loading their data warehouses.

                      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.

                      Code Download and Errata
                      Packt Anytime, Anywhere
                      Register Books
                      Print Upgrades
                      eBook Downloads
                      Video Support
                      Contact Us
                      Awards Voting Nominations Previous Winners
                      Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                      Resources
                      Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software