Oracle Business Intelligence Data Warehouse Administration Console (Oracle DAC) provides a centralized console for schema management, configuration, administration, loading, and monitoring of the Oracle Business Analytics Warehouse. Designed specifically for organizations using Oracle Business Intelligence Applications Fusion Edition implementing Informatica PowerCenter as their ETL tool, Oracle DAC offers a rich suite of application-specific features that complement the 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.
|
