Skip Headers
Oracle® Business Intelligence Data Warehouse Administration Console Guide
Version 7.9.5
Part Number E12085-01
Home
Book List
Index
Contact Us
Next
View PDF
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