What is DAC?

Data Warehouse Administration Console (DAC)

The DAC is a metadata driven “ETL process management tool” and provides a framework for the entire life cycle of a data warehouse implementation. It enables ETL administrators to create, configure, execute, and monitor modular data warehouse applications in a parallel, highperforming environment. The DAC complements the ETL platform. It provides application specific capabilities that are not prebuilt into ETL platforms. For example, ETL platforms are not aware of the semantics of the subject areas being populated in the data warehouse nor the method in which they are populated. The DAC provides the following application capabilities at a layer of abstraction above the ETL execution 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

• Automatic full and incremental mode awareness

• Index management for ETL and query performance

• Embedded high performance Siebel OLTP change capture techniques

• Ability to restart at any point of failure

• Phase-based analysis tools for isolating ETL bottlenecks

The benefits of the DAC include

• Pin-point deployment of required Oracle BI Applications modules

• Load balancing / parallel loading

• Reduced load windows

• Fine-grained failure recovery

• Index management

• Database statistics collection