| Oracle® Warehouse Builder User's Guide 11g Release 1 (11.1) Part Number B31278-01 |
|
|
View PDF |
| Oracle® Warehouse Builder User's Guide 11g Release 1 (11.1) Part Number B31278-01 |
|
|
View PDF |
This preface includes the following topics:
Changes in the Installation Requirements and Instructions
Previously, if you wanted to utilize Oracle Workflow to manage job dependencies or if you wanted to deploy process flows, it was necessary to install Oracle Workflow. Beginning in this release, these additional installation steps are no longer required as Oracle Workflow components are embedded within Warehouse Builder.
Previously, each Oracle Database utilized as a repository for this product required a user with SYSDBA privileges. Beginning in this release, this is no longer required. A schema OWBSYS is created while installing Oracle Database 11g Release 1 (11.1). OWBSYS holds the metadata which is divided into workspaces. To start using Warehouse Builder, you just need to create a new workspace. You do not need SYSDBA privileges.
Previously, users accessed the repository as a whole. Therefore, users were referred to as repository users and repository owners. Beginning with this release, repository is replaced with workspace. Thus, instead of granting access to a repository, you grant access to a workspace. Because of the usage of workspaces in a single schema, creating workspaces is simplified.
Beginning with Warehouse Builder11g Release 1 (11.1), the preferred method of implementing metadata security is through the user interface available in the Design Center and described in the Oracle Warehouse Builder User's Guide. If, in a previous release, you implemented security using a PL/SQL package, Warehouse Builder 11g Release 1 (11.1) does support that implementation.
For additional information, refer to the Oracle Warehouse Builder Installation and Administration Guide.
Connectivity to Siebel
With Oracle Warehouse Builder 11g Release 1 (11.1), an application connector to Siebel is added. This connector allows you to connect to the Siebel metadata as could be done in previous versions with Oracle E-Business Suite, PeopleSoft, and SAP. For more information, see "Integrating with Siebel".
Additions to Dimensional Objects
There are some modifications to the functionality for updating records in a Type 2 Slowly Changing Dimension (SCD). For more information, see "Updating Type 2 Slowly Changing Dimensions".
You can now version hierarchies in a Type 2 SCD. For information about enabling hierarchy versioning, see "Hierarchy Versioning".
Improvements to the Documentation Set
In this release, the documentation set has been reorganized and revised.
The book formerly entitled the Oracle Warehouse Builder Installation and Configuration Guide is now entitled the Oracle Warehouse Builder Installation and Administration Guide and includes administration information such as implementing security.
The Oracle Warehouse Builder User's Guide now includes enhanced introductory and conceptual information. Related reference material organized by subject matter is now contained in the Oracle Warehouse Builder Online Help.
The Oracle Warehouse Builder API and Scripting Reference now includes information on using experts and the Expert Editor, which was formerly contained in the Oracle Warehouse Builder User's Guide.
