DAC (OBIEE)

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

• Enables remote admin and monitoring
• Provides runtime metadata validation checks
• Provides in-context documentation