DAC stands for Data Warehouse Application Console.  It is an essential component of Oracle BI application architecture.

DAC serves the following purposes:

1. DAC is a metadata driven administration and deployment tool for ETL and data warehouse objects

 

2. Used by warehouse developers and ETL Administrator

 

3. Application Configuration

 

  • Manages metadata-driven task dependencies and relationships
  • Allows creating custom ETL execution plans
  • Allows for dry-run development and testing

4. Execution

  • Enables parallel loading for high performance ETL
  • Facilitates in index management and database statistics collection
  • Automates change capture for Siebel OLTP
  • Assists in capturing deleted records
  • Fine grain restartability

5. Monitoring