Dac

DAC stand for Datawarehouse  Administration Console

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

DAC Running modes

Orange ->  Indicates Running  State

Red -> Indicates not Running 

Green ___> Executing ETL

DAC Life Cycle:

1. Step: step db connections
2.  set up ETL  processes
3. setup email receipients

 Desing : -> define application objects

             -> design execution plans

Execution: Define scheduling parameters

              ->Access runtime controls to restart or stop 

Monitor: Monitor runtime Execution of DWH

DAC Object Hierarchy