Skip Headers
Oracle® Business Intelligence Data Warehouse Administration Console User's Guide
Version 10.1.3.4
Part Number E12652-02
Home
Book List
Index
Contact Us
Next
View PDF
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
Scripting on this page enhances content navigation, but does not change the content in any way.