Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide > Overview of Siebel Data Warehouse >
About the Data Warehouse Application Console
The Data Warehouse Application Console (DAC) is a centralized console, providing access to the entire Siebel Data Warehouse application. It allows you to create, configure, and execute modular data warehouse applications in a parallel, high-performing environment.
Important features of the DAC include the following:
- Single command and control point for the Siebel Data Warehouse
- Dynamic load balancing of Informatica workflows across servers
- Dynamic load balancing of database tasks (non-Informatica) across database connections and databases
- Metadata-driven ETL execution plans and drop and create indices
- Registration of Informatica servers, Informatica databases, and source and target databases
- Automated configuration of ETL for full and incremental load of selected data warehouse subject areas
- Intelligent prioritization of sessions in queue during execution based on estimated run time and other criteria
- Structured history tracking and categorization of diagnostic logs by execution plans rather than by sessions
- Customization and extension of data warehouse subject areas
- Scheduling and optimal execution of the ETL process based on database and hardware resources
- Restarting of the ETL process from point of failure
- Email notification about the status of ETL processes
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide Published: 11 March 2004 |