Dylan’s BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

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

3 Responses to “DAC (OBIEE)”

  1. [...] do I need to use DAC from Oracle BI EE? By Rakesh Butkury Data Warehouse Application Console (DAC) works together with Informatica to acomplish the ETL for pre-packaged BI [...]

  2. [...] Data Warehouse Application Console (DAC) works together with Informatica to acomplish the ETL for pre-packaged BI applications. [...]

  3. […] DAC (OBIEE) […]

 
Follow

Get every new post delivered to your Inbox.

Join 36 other followers

%d bloggers like this: