|Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Data Warehouse Administration Console
11g Release 1 (11.1.1)
Part Number E14849-04
|PDF · Mobi · ePub|
This chapter lists the new features in the current release of Oracle Business Intelligence Data Warehouse Administration Console (DAC). It also provides information about hardware and software requirements, platforms, and databases.
The chapter contains the following topics:
New DAC features include the following:
Functional Setup for Task Level Parameters
The functional setup of task level parameters is an operation that you now perform using the Oracle Business Intelligence Applications Configuration Manager. For more information, see Oracle Fusion Middleware Installation and Configuration Guide for Oracle Business Intelligence Applications.
See Chapter 1, "About DAC Security," for information about the new DAC security model. For information about the differences between standalone mode and Fusion Middleware mode, see "DAC Authentication in Oracle Fusion Middleware (WebLogic Server) Mode" and "DAC Authentication in Standalone Mode".
Enhancement for Index Creation
DAC now supports the creation of query indexes in parallel immediately following the creation of ETL-related indexes. DAC notifies the successor tasks as soon as the ETL indexes have been created, allowing query indexes and additional unique indexes to be created sooner. See "Managing Indexes" for more information.
Creation of Indexes in Parallel for a Specific Table
DAC now enables you to specify how many indexes can be created in parallel for a specific table or how many indexes can be created in parallel for all tables associated with a specific physical data source connection. See "Specifying How Many Indexes Can Be Created in Parallel" for more information.
Testing an Individual Workflow
You can test an individual workflow before running a full execution plan. See "Unit Testing Execution Plan Tasks" for more information.
Enhancement for Prune Time Property
See "Execution Plans Tab: Connectivity Parameters Subtab" for more information.
Running Execution Plans Concurrently
You can configure DAC to run multiple execution plans concurrently if the execution plans are independent of one another, that is, as long as the execution plans do not load data into the same table on the same physical data source. See "Running Execution Plans Concurrently" for more information.
Looping of Workflows
You can configure the full and incremental load commands for tasks to repeat (or loop) multiple times during the execution of an ETL process. See "Looping of Workflows" for more information.
You can set up event delays to configure the extracts for different data sources to occur independently. See "Setting Up Extract Delays, Event Delays and Data Source Notifications" for more information.
Using Heuristics to Manage Tasks, Tables and Indexes
The DAC heuristics feature enables you to gather intelligence about the amount of incremental data that will be processed during an ETL execution. To optimize performance, you can use this intelligence to decide how to manage the behavior of tasks, tables, and indexes. See "Using Heuristics to Manage Tasks, Tables and Indexes" for more information.
Integrating DAC With Other ETL Tools
The external executor framework enables you to integrate DAC with ETL engines other than Informatica. See "Integrating DAC With Other ETL Tools" for more information.
Working With DAC Metadata Patch Sets
The DAC metadata patch feature enables you to import and export subsets of DAC metadata at a fine grain. See "Working With DAC Metadata Patches" for more information.
Creating and Upgrading the Data Warehouse Schema
DAC provides new functionality to create or upgrade data warehouse schemas. See Chapter 9, "Managing Data Warehouse Schemas," for more information.
EM Beans Implementation
Fusion Middleware Control MBean Browser is an Oracle Web application (based on JMX MBean containers) that you can use to view information about running, failed and queued execution plans and the status of the DAC Server. See "Viewing DAC Metrics Using Fusion Middleware Control MBean Browser" for more information.
Moving a DAC Environment
Oracle Fusion Middleware provides movement scripts that enable you to move components and configurations from a development or test environment to a production environment. When DAC is installed in an Oracle Fusion Middleware environment and you run the movement scripts, DAC components and configurations are moved along with the other Oracle Fusion Middleware components. The section "Moving a DAC Environment Using Oracle Fusion Middleware Movement Scripts" provides information about this process.
Revision 3 of Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Data Warehouse Administration Console (11.1.1) contains the following updates:
Support for handling failed tasks while an execution plan is still running. See "Using DAC's Hotfix Capability to Handle Failed Tasks While an Execution Plan Is Still Running".
Enhancements to the DAC patching feature that enable you to have subject areas automatically assembled and execution plans automatically rebuilt when these objects are applied to a repository as patch contents. See "Working With DAC Metadata Patches".
Enhancements to the concurrent ETL feature that enable you to define an execution plan prefix in order to run concurrent execution plans that share common tasks. See "Execution Plans That Are Eligible to Run Concurrently".
A new Task by Depth right-click command in the Execution Plans tab of the Execute view, which shows how many tasks in an execution plan are at each depth level. See "Performance Tuning the ETL Process Using Tasks by Depth Command".
Enhancements to performance tuning by creating logical partitions on load tasks. See "Creating Logical Partitions on Load Tasks to Increase Performance".
General quality enhancements throughout the guide.
Revision 4 of Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Data Warehouse Administration Console (11.1.1) contains the following updates:
Support for creating multiple instances of an execution plan that can run concurrently. See "Running Multiple Instances of an Execution Plan".
A new extended property in the Extended Properties subtab of the Physical Data Sources tab in the Setup view called Time Difference Override. This property is used to specify the time difference between the DAC Server machine and the physical data source database machine. See "Physical Data Sources Tab: Extended Properties Subtab".
General quality enhancements throughout the guide.
Refer to the system requirements and certification documentation for information about hardware and software requirements, platforms, databases, and other information. Both of these documents are available on Oracle Technology Network (OTN).
The system requirements document covers information such as hardware and software requirements, minimum disk space and memory requirements, and required system libraries, packages, or patches:
The certification document covers supported installation types, platforms, operating systems, databases, JDKs, and third-party products: