Oracle® Business Intelligence Data Warehouse Administration Console Guide > Overview of Oracle Business Analytics Warehouse >
About the Data Warehouse Administration Console
The DAC provides a framework for the entire life cycle of data warehouse implementations. It allows you to create, configure, execute, and monitor modular data warehouse applications in a parallel, high-performing environment. For information about the DAC process life cycle, see About the DAC Process Life Cycle. The DAC complements the Informatica 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 these application capabilities at a layer of abstraction above the ETL execution platform, as illustrated in Figure 3.
Figure 3. DAC Application-Specific Capabilities
|
Important DAC Features
Important DAC features allow you to do the following: Minimize install, setup, and configuration time - Create physical data model in the data warehouse
- Set language, currency, and other settings
- Design subject areas and build execution plans
Manage metadata driven dependencies and relationships - Generate custom ETL execution plans
- Automate change capture for the Siebel transactional database
- Capture deleted records
- Assist in index management
- Perform dry runs and test runs of execution plans
Provide reporting and monitoring to isolate bottlenecks - Perform error monitoring and email alerting
- Perform structured ETL analysis and reporting
Utilize performance execution techniques
|