Oracle® Business Intelligence Data Warehouse Administration Console Guide
What's New in This Release
Back to top
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
About Source System Containers
About DAC Repository Objects
About the DAC Process Life Cycle
DAC Quick Start
Overview of the DAC Interface
Navigating the DAC Interface
The DAC's Menu Bar
The DAC's Views
The DAC's Top Pane Toolbar
The DAC's Right-Click Menus
The DAC's Server Monitor Icons
The DAC's Navigation Tree
The DAC's Editable Lists
Using the DAC Query Functionality
DAC Query Commands and Operators
DAC Query Examples
Common DAC Query Procedures
Using Flat Views Querying
About Object Ownership in the DAC
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
Setting Source System Parameters
Setting Task Level Parameters
Working with Configuration Tags
Considerations in Designing a Subject Area
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
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
Setting Up Command Line Access to the DAC Server
Using the Command Line to Access the DAC Server
DAC Repository Command Line Options
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
Overview of Change Capture Process (Siebel Sources Only)
Initial Data Capture
Change Capture Mechanisms
Using the Change Capture Filter
Tracking Deleted Records
Handling ETL Failures with the DAC
DAC Functional Reference
Common Elements of DAC Interface Tabs
About the DAC Design View
About the DAC Subject Areas Tab
About the DAC Tables Tab
About the DAC Indices Tab
About Advanced Custom Index Management
About the DAC Tasks Tab
About the DAC Task Groups Tab
About the DAC Configuration Tags Tab
About the DAC Source System Parameters Tab
About the DAC Source System Folders Tab
About the DAC Setup View
About the DAC System Properties Tab
About the Informatica Servers Tab
About the Physical Data Sources Tab
About the Email Recipients Tab
About the DAC Execute View
About the DAC Execution Plans Tab
About the DAC Current Run Tab
About the DAC Run History Tab
About the DAC Scheduler Tab