|Oracle® Warehouse Builder User's Guide
11g Release 1 (11.1)
|PDF · Mobi · ePub|
This preface includes the following topics:
Due to significant changes in product architecture and security, this release introduces changes to the process for installing Warehouse Builder. For information, refer to the Oracle Warehouse Builder Installation and Administration Guide.
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.
Oracle Warehouse Builder 11g Release 1 (11.1) provides connectors that enable you to perform data profiling and data correction for Oracle Master Data Management (MDM) applications. This functionality is called Data Watch and Repair and can be used with the following MDM applications: Customer Data Hub (CDH), Product Information Management (PIM), and Universal Customer Master (UCM).
For more information about Data Watch and Repair, see "Setting Data Watch and Repair for Oracle Master Data Management (MDM)".
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".
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".
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. Certain sections that were only included in the online help of the documentation set are now included in the Oracle Warehouse Builder User's Guide.
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.