DAC Process Life Cycle

DAC is used by different user groups to design, execute, monitor, and diagnose

execution plans. These phases together make up the DAC process life cycle, as shown

in Figure 3–2.

Figure 3–2 DAC Process Life Cycle

 The phases of the process and the actions associated with them are as follows:

Setup

– Set up database connections

– Set up ETL processes (Informatica)

– Set up email recipients

 Design

– Define application objects

– Design execution plans

 Execute

– Define scheduling parameters to run execution plans

– Access runtime controls to restart or stop currently running schedules

 Monitor

– Monitor runtime execution of data warehouse applications

– Monitor users, DAC repository, and application maintenance jobs