Oracle® Business Intelligence Data Warehouse Administration Console User's Guide Version 10.1.3.4 Part Number E12652-02 |
|
|
View PDF |
The first section lists changes described in this version of the documentation to support releases 10.1.3.4 of the software.
The second section lists changes described in this version of the documentation to support releases 10.1.3.4.1 of the software.
The Oracle Business Intelligence Data Warehouse Administration Console User's Guide includes the following new and changed topics:
User Management. The User Management feature enables you to create and manage user accounts. See "About User Account Management".
DAC Repository Database Authentication File. Upon logging into DAC for the first time, the DAC Repository Database Authentication File authenticates the database in which the repository resides. See "DAC Repository Database Authentication File".
Best Practices for Defining Repository Objects. See "Best Practices for Defining Repository Objects".
Enhanced Subject Area Design. See "Customizing DAC Objects and Designing Subject Areas".
Enhanced Execution Plan Design. See "Building, Running and Monitoring Execution Plans".
Multi-Source Execution Plans. See "About Multi-Source Execution Plans".
Repository Audit Trail. See "Tools Menu Options".
Actions Feature. Provides a flexible way to drop and create indexes, truncate and analyze tables, and define SQL scripts to enhance task behaviors. See "About Index, Table and Task Actions".
Upgrade/Merge Wizard. Enables you to upgrade and merge DAC repositories by comparing repositories and creating a Difference Report. See "Upgrading, Comparing and Merging DAC Repositories"
The Oracle Business Intelligence Data Warehouse Administration Console User's Guide revision 1 includes the following topics originally published in the Oracle Business Intelligence Applications Release Notes for 10.1.3.4 and new features in version 10.1.3.4.1:
Informatica Password Encryption. By default, passwords are unencrypted when DAC interacts with Informatica; however, you can force password encryption. See "Forcing Password Encryption When DAC Interacts With Informatica".
Creating Parallel Indexes. DAC can create parallel indexes by table. See "Physical Data Sources Tab: Parallel Indexes Subtab".
Worker Pool Size. This is a new system property that specifies the number of worker threads that perform various operations. See "Worker Pool Size".
Multi-Line Parameters. You can configure the infa_command.xml file to enable the parameter file to contain multi-line parameters. See "Handling Parameter Files with Multi-Line Parameters".
Restoring DAC Repository on Unicode Oracle Database. On a non-Unicode Oracle database the Informatica workflow names may not fit into the corresponding fields. See "Restoring the DAC Repository on Unicode Oracle Databases".
Password Management. Users in all roles can change their passwords. See "About User Account Management".
Prune Days. Prune days can be set by source for multi-source ETL. See "Prune Days".
JDBC Override. JDBC connection "URL Override" handles specific database connections. See "Using JDBC Connection URL Override to Handle Database Connections".
Upgrading the Data Warehouse Schema on Teradata. When the data warehouse schema is on a Teradata database and you use the Data Warehouse Configuration Wizard to upgrade the data warehouse schema, DAC generates SQL scripts and log files. For a description of these files, see "Upgrading the Data Warehouse Schema on Teradata".
DAC Parameter Load Specification. DAC Parameters can be specified for full or incremental load ETLs. See "Using Parameters to Specify Full or Incremental Loads".
Mapping Multiple Workflows. Multiple database-specific Informatica workflows can be mapped to the same DAC task. See "Mapping Multiple Database-Specific Informatica Workflows to the Same DAC Task".
Connecting to DAC When Using Oracle RAC. Use a specific URL to connect to the DAC repository when using Oracle RAC. See "Connecting to the DAC Repository When Using Oracle RAC".