Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 What's New in This Release

• What's New in Oracle Business Intelligence Data Warehouse Administration Console User's Guide, Release 10.1.3.4
• What's New in Oracle Business Intelligence Data Warehouse Administration Console User's Guide, Release 10.1.3.4.1

2 Overview of Oracle Business Analytics Warehouse

• Oracle Business Analytics Warehouse Overview
• Oracle Business Analytics Warehouse Architecture
  • Oracle Business Analytics Warehouse Architecture Components

3 Basic Concepts About DAC

• Introduction to DAC
  • Important DAC Features
• About the DAC Process Life Cycle
• About Source System Containers
• About DAC Repository Objects Held in Source System Containers
• About Object Ownership in DAC
• About DAC Metadata Export Behavior

4 DAC Quick Start

• About User Account Management
  • Creating, Deleting and Inactivating User Accounts
• Logging into DAC for the First Time
• About the DAC's Extract and Load Processes
  • Performing an Initial Full Load of Data into the Data Warehouse

5 Best Practices for Defining Repository Objects

• Best Practices for Containers
• Best Practices for Tasks
• Best Practices for Task Groups
• Best Practices for Tables
• Best Practices for Indexes
• Best Practices for Columns
• Best Practices for Configuration Tags
• Best Practices for Source System Parameters
• Best Practices for Subject Areas
• Best Practices for Execution Plans

6 Overview of the DAC Interface

• Navigating the DAC Interface
• The DAC Menu Bar
  • Tools Menu Options
• The DAC Views
• The DAC Top Pane Toolbar
• The DAC Right-Click Menus
  • Common Right-Click Menu Commands
  • Design View Right-Click Menu Commands
  • Setup View Right-Click Menu Commands
  • Execute View Right-Click Menu Commands
• The DAC Server Monitor Icons
• The DAC Navigation Tree
• The DAC Editable Lists
• Font Variations of Objects Displayed in the DAC
• Using the DAC Query Functionality
  • DAC Query Commands and Operators
  • DAC Query Examples
  • Common DAC Query Procedures
  • Using Flat Views Querying

7 About Index, Table and Task Actions

• Overview of Index, Table and Task Actions
• Defining a SQL Script for an Action
• Assigning an Action to a Repository Object
• Functions for Use with Actions
• Example of How to Use a DAC Source System Parameter in an Action

8 Customizing DAC Objects and Designing Subject Areas

• Creating or Copying a Source System Container
• About Customizing the Data Warehouse
• Adding a New Table and Columns to the Data Warehouse
• Adding an Index to the Data Warehouse
• Importing New Data Warehouse Objects into the Informatica Repository
• Creating Informatica Mappings and Workflows
• Creating Tasks in the DAC for New or Modified Informatica Workflows
• Setting a Task Phase Dependency
• Creating a Task Group
• About Parameter Management
  • Overview of Parameters
    • Parameter Data Types
  • Preconfigured Parameters
  • How DAC Handles Parameters at Runtime
  • Nesting Parameters within Other Parameters
  • Defining a Text Type Parameter
  • Defining a Database Specific Text Type Parameter
  • Defining a Timestamp Type Parameter
  • Defining a SQL Type Parameter
• Specifying Tablespaces for Indexes by Table Type
• Working with Configuration Tags
• Overview of Subject Areas
  • Designing a Subject Area
    • Previewing and Pruning Subject Areas
  • How DAC Determines Tasks Required for Subject Areas
• Creating a Subject Area

9 Building, Running and Monitoring Execution Plans

• Types of Execution Plans
  • About Single-Source Execution Plans
  • About Multi-Source Execution Plans
    • Multi-Source Order of Execution
    • Delay
    • Folder Level Priorities
• Common Extract and Load Scenarios
  • Single Extract and Single Load Scenario
    • Truncate Table Behavior in a Single Extract Scenario
  • Multiple Extract and Single Load Scenario
    • Truncate Table Behavior in a Multiple Extract Scenario
  • Multiple Extract and Multiple Load Scenario
• Best Practices for Multi-Source Execution Plans
• How DAC Determines the Order of Task Execution within an Execution Plan
• Building and Running Single-Source and Multi-Source Execution Plans
• Unit Testing Execution Plan Tasks
• Building and Running Micro ETL Execution Plans
• Scheduling an Execution Plan
• About Refresh Dates
• Monitoring Execution Plan Processes

10 Upgrading, Comparing and Merging DAC Repositories

• Overview of Upgrade/Merge Wizard
  • Major Stages of the Upgrade/Merge Wizard
  • Resetting the Upgrade or Merge Process
• Overview of Upgrade and Merge Options
• About the Repository Upgrade (DAC 784) Option
  • Repository Upgrade (784): High-Level Process Flow
  • Repository Upgrade (784): Procedure for Upgrading
• About the Refresh Base Option
  • Refresh Base: High-Level Process Flow
  • Refresh Base: Procedure for Upgrading
• About the Simplified Refresh From Base Option
• About the Replace Base Option
  • Replace Base: High-Level Process Flow
  • Replace Base: Procedure for Upgrading
• About the Peer to Peer Merge Option
  • Peer to Peer Merge: High-Level Process Flow
  • Peer to Peer Merge: Procedure for Merging
• Resolving Object Differences in the View Difference Report
  • Overview of View Difference Report
  • View Difference Report Interface
  • Possible Repository Merge Outcomes Based on Your Decisions

11 Common Tasks Performed in the DAC

• Importing DAC Metadata
• Exporting DAC Metadata
• Distributing DAC Metadata
• Running the DAC Server Automatically
• Command Line Access to the DAC Server
  • Command Line Operations
  • Starting an Execution Plan
    • Stopping the Operation of a Running Execution Plan
    • Command Line Status Monitoring Queries
  • Setting Up Command Line Access to the DAC Server
  • Using the Command Line to Access the DAC Server
• DAC Repository Command Line Options
  • Import DAC Metadata by Application
  • Export DAC Metadata by Application
  • Import DAC Metadata by Categories
  • Export DAC Metadata by Categories
  • Create Schema
  • Drop Schema
  • Analyze
  • Upgrade
  • Set Password
• Replacing an Informatica Workflow with a Custom SQL File
• Determining the Informatica Server Maximum Sessions Parameter Setting
• Determining the Number of Transactional and Data Warehouse Database Connections
• Running Two DAC Servers on the Same Machine
• Customizing Index and Analyze Table Syntaxes
• Overview of Change Capture Process (Siebel Sources Only)
  • Initial Data Capture
  • Change Capture Mechanisms
    • Change Capture Using Tables
    • Change Capture Using the Date Column
• Using the Change Capture Filter
• Tracking Deleted Records
• Pointing Multiple Informatica PowerCenter Services to a Single Informatica Repository
• Handling ETL Failures with the DAC
  • When the Execution of an Execution Plan Fails
  • In Case of Abnormal Termination of the DAC Server
  • Discarding the Current Run Execution Plan
  • Failure of Aggregator Transformation Tasks with Sorted Input
• Forcing Password Encryption When DAC Interacts With Informatica
• Upgrading the Data Warehouse Schema on Teradata
• Using JDBC Connection URL Override to Handle Database Connections
• Using Parameters to Specify Full or Incremental Loads
• Mapping Multiple Database-Specific Informatica Workflows to the Same DAC Task
• Connecting to the DAC Repository When Using Oracle RAC

12 DAC Functional Reference

• Common Elements of Interface Tabs
• Design View Tabs
  • Configuration Tags Tab
    • Configuration Tags Tab: Subject Areas Subtab
    • Configuration Tags Tab: Tasks Subtab
  • Indices Tab
    • Indices Tab: Actions Subtab
    • Indices Tab: Columns Subtab
  • Source System Folders Tab
  • Source System Parameters Tab
  • Subject Areas Tab
    • Subject Areas Tab: Configuration Tags Subtab
    • Subject Areas Tab: Extended Tables (RO) Subtab
    • Subject Areas Tab: Tables Subtab
    • Subject Areas Tab: Tasks Subtab
    • Subject Areas Tab: Task Source Tables (RO) Subtab
    • Subject Areas Tab: Task Target Tables (RO) Subtab
  • Tables Tab
    • Tables Tab: Actions Subtab
    • Tables Tab: Conditional for Tasks (RO) Subtab
    • Tables Tab: Columns Subtab
    • Tables Tab: Indices (RO) Subtab
    • Tables Tab: Multi-Column Statistics Subtab
    • Tables Tab: Related Tables Subtab
    • Tables Tab: Source for Tasks (RO) Subtab
    • Tables Tab: Target for Tasks (RO) Subtab
  • Task Groups Tab
    • Task Groups Tab: Child Tasks Subtab
    • Task Groups Tab: Source Tables (RO) Subtab
    • Task Groups Tab: Target Tables (RO) Subtab
  • Tasks Tab
    • Tasks Tab: Actions Subtab
    • Tasks Tab: Conditional Tables Subtab
    • Tasks Tab: Configuration Tags Subtab
    • Tasks Tab: Parameters Subtab
    • Tasks Tab: Phase Dependency Subtab
    • Tasks Tab: Refresh Date Tables Subtab
    • Tasks Tab: Source Tables Subtab
    • Tasks Tab: Target Tables Subtab
• Setup View Tabs
  • DAC System Properties Tab
  • Email Recipients Tab
  • Informatica Servers Tab
  • Physical Data Sources Tab
    • Physical Data Sources Tab: Index Spaces Subtab
    • Physical Data Sources Tab: Parallel Indexes Subtab
    • Physical Data Sources Tab: Analyze Frequencies Subtab
    • Physical Data Sources Tab: Refresh Dates Subtab
• Execute View Tabs
  • Current Run Tab
    • Current Run Tab: Audit Trail (RO) Subtab
    • Current Run Tab: Phase Summary (RO) Subtab
    • Current Run Tab: Run Type Summary (RO)
    • Current Run Tab: Tasks Subtab
    • Current Run Tab: Task Details Subtab
  • Execution Plans Tab
    • Execution Plans Tab: All Dependencies Subtab
    • Execution Plans Tab: Following Tasks Subtab
    • Execution Plans Tab: Immediate Dependencies Subtab
    • Execution Plans Tab: Ordered Tasks Subtab
    • Execution Plans Tab: Parameters Subtab
    • Execution Plans Tab: Preceding Tasks Subtab
    • Execution Plans Tab: Refresh Dates Subtab
    • Execution Plans Tab: Subject Areas Subtab
    • Execution Plans Tab: Tables (RO) Subtab
  • Run History Tab
    • Run History Tab: Audit Trail (RO) Subtab
    • Run History Tab: Phase Summary (RO) Subtab
    • Run History Tab: Run Type Summary (RO) Subtab
  • Scheduler Tab

A Troubleshooting DAC

• Handling Parameter Files with Multi-Line Parameters
• Restoring the DAC Repository on Unicode Oracle Databases

Index