Contents

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 Guide, Version 7.9.5

2 Overview of Oracle Business Analytics Warehouse

• Oracle Business Analytics Warehouse Overview
• Oracle Business Analytics Warehouse Architecture
  • Oracle Business Analytics Warehouse Architecture Components
• About the Data Warehouse Administration Console
  • Important DAC Features
• About Source System Containers
  • About DAC Repository Objects
  • About the DAC Process Life Cycle
• About the DAC's Extract and Load Processes
  • Performing an Initial Full Load of Data into the Data Warehouse

3 DAC Quick Start

4 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
• About Object Ownership in the DAC
  • Font Variations of Objects Displayed in the DAC
  • Object Behaviors To Consider
• Using the DAC Query Functionality
  • DAC Query Commands and Operators
  • DAC Query Examples
  • Common DAC Query Procedures
  • Using Flat Views Querying

5 Customizing, Designing, Executing and Monitoring ETL Processes

• 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 the 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
• Considerations in Designing a Subject Area
  • Designing a Subject Area
  • How the DAC Determines Tasks Required for Subject Areas
  • How the DAC Determines the Order of Task Execution within an Execution Plan
• Creating a Subject Area
• Building and Running an Execution Plan with the DAC
• Creating a Micro ETL Execution Plan
• Scheduling an Execution Plan
• About Refresh Dates
• Monitoring Execution Plan Processes

6 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
• Using SQL Files as an Execution Type in the DAC
  • XML Formatted Files
    • Use of CDATA Section
    • Runtime Substitution of Keywords
    • Example of XML Formatted File
  • Plain Text SQL Files
• 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

7 DAC Functional Reference

• Common Elements of Interface Tabs
• Design View Tabs
  • Configuration Tags Tab
  • Indices Tab
  • Source System Folders Tab
  • Source System Parameters Tab
  • Subject Areas Tab
  • Tables Tab
  • Task Groups Tab
  • Tasks Tab
• Setup View Tabs
  • DAC System Properties Tab
  • Email Recipients Tab
  • Informatica Servers Tab
  • Physical Data Sources Tab
• Execute View Tabs
  • Current Run Tab
  • Execution Plans Tab
  • Run History Tab
  • Scheduler Tab

Index