OBIA - Data Warehouse Application Console (DAC)

Card Puncher Data Processing

OBIA - Data Warehouse Application Console (DAC)


DAC is a command and control interface for the OBIA data warehouse to allow for set up, configuration, administration, and monitoring of data warehouse processes.

Designed specifically for organizations using Oracle Business Intelligence Applications implementing Informatica PowerCenter as their ETL tool, Oracle DAC offers a rich suite of application-specific features that complement the Informatica ETL platform:

  • Dynamic generation of subject areas and execution plans
  • Dynamic settings for parallelism and load balancing
  • Intelligent task queue engine based on user-defined and computed scores
  • Index management for ETL and query performance
  • Embedded high-performance OTLP change capture techniques
  • Restart from any point of failure
  • Phase-based analysis tools for isolating ETL bottlenecks

Other Oracle DAC features help you minimize installation, setup, and configuration time; manage metadata driven dependencies and relationships; and apply performance-based execution techniques.


Some parameters are defined as Source System Parameters… Other are defined in the task (Design > Tasks > select and choose the Parameters tab below).

Why do I need to use DAC ?

Posted by Dylan Wan on January 8, 2007

Data Warehouse Application Console (DAC) works together with Informatica to acomplish the ETL for pre-packaged BI applications.

Here are what happen behind the scene:

  • DAC publish the changes from OLTP
  • Informatica extracts the changes from the change log published by DAC as well as from the base table
  • Informatica load the data to the stage tables and the target tables in the data warehouse
  • DAC manage the performance by dropping indexes, truncating stage tables, rebuilding the indexes, and analyzing the tables during the process

If you do not use DAC, you have to write your own custom change capture process and need to redesign from scratch an ETL method that allow the restart of the ETL process from point of failure at record level. The biggest saving is that DAC can survive during the upgrade , while your custom processes cannot.

Discover More
Card Puncher Data Processing
DAC - User Account Management

The User Management feature includes three roles: Administrator, Developer, and Operator. Each role has a set of permissions that determines what DAC functionality the role can access. Role Permissions...
Obia Overview
OBIA - Architecture with Informatica Powercenter and DAC

use (in some version) : as and Data Warehouse Application Console as monitoring tool DAC is a command and control interface for the data warehouse to allow for set up, configuration, administration,...
Obia Powercenter Topology
OBIA - Installation Version 7.9.6 with EBS, PowerCenter, Oracle Database on Windows

Roadmap To install and set up Oracle BI Applications, do the following: preinstallation steps for the source...
Card Puncher Data Processing
Oracle Business Intelligence Application (OBIA)

Oracle BI Applications is a business intelligence application which is a prebuilt solution. Oracle BI Applications supports: Oracle sources, such as: Oracle E-Business Suite Applications, Oracle's...

Share this page:
Follow us:
Task Runner