Scribd Logo
Upload

Welcome to Scribd!

  • 17 views

    Dac (Obiee)

    Uploaded by

    Venoo Goopal
    DAC (Data Warehouse Application Console) is a metadata-driven administration and deployment tool used for ETL and data warehouse objects. It manages task dependencies and relationships, allows custom ETL execution plans and dry-run development/testing. DAC enables parallel loading for high performance ETL, facilitates index management/statistics collection, and automates change capture for Siebel OLTP while assisting with deleted records and fine-grain restartability. DAC works with Informatica to accomplish ETL for pre-packaged BI applications by publishing OLTP changes, allowing Informatica to extract changes and load data into stage and target tables while managing performance.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd

    Dac (Obiee)

    Uploaded by

    Venoo Goopal
    17 views2 pages
    DAC (Data Warehouse Application Console) is a metadata-driven administration and deployment tool used for ETL and data warehouse objects. It manages task dependencies and relationships, allows custom ETL execution plans and dry-run development/testing. DAC enables parallel loading for high performance ETL, facilitates index management/statistics collection, and automates change capture for Siebel OLTP while assisting with deleted records and fine-grain restartability. DAC works with Informatica to accomplish ETL for pre-packaged BI applications by publishing OLTP changes, allowing Informatica to extract changes and load data into stage and target tables while managing performance.

    Original Title

    DAC(OBIEE)

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    DAC (Data Warehouse Application Console) is a metadata-driven administration and deployment tool used for ETL and data warehouse objects. It manages task dependencies and relationships, allows custom ETL execution plans and dry-run development/testing. DAC enables parallel loading for high performance ETL, facilitates index management/statistics collection, and automates change capture for Siebel OLTP while assisting with deleted records and fine-grain restartability. DAC works with Informatica to accomplish ETL for pre-packaged BI applications by publishing OLTP changes, allowing Informatica to extract changes and load data into stage and target tables while managing performance.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    17 views2 pages

    Dac (Obiee)

    Uploaded by

    Venoo Goopal
    DAC (Data Warehouse Application Console) is a metadata-driven administration and deployment tool used for ETL and data warehouse objects. It manages task dependencies and relationships, allows custom ETL execution plans and dry-run development/testing. DAC enables parallel loading for high performance ETL, facilitates index management/statistics collection, and automates change capture for Siebel OLTP while assisting with deleted records and fine-grain restartability. DAC works with Informatica to accomplish ETL for pre-packaged BI applications by publishing OLTP changes, allowing Informatica to extract changes and load data into stage and target tables while managing performance.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    of 2

    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

    Why do I need to use DAC from Oracle BI EE?


    Data Warehouse Application Console (DAC) works together with Informatica to acomplish the ETL for pre-packaged BI applications. Here are what happen behind the scene:
    DAC publish the changes from OLTP Informatica extracts the changes from the change log published by DAC as well as from

    the base table

    Informatica load the data to the stage tables and the target tables in the data

    warehouse

    DAC manage the performance by dropping indexes, truncating stage tables, rebuilding

    the indexes, and analyzing the tables during the process

    If you do not use DAC, you have to write your own custom change capture process and need to redesign from scratch an ETL method that allow the restart of the ETL process from point of failure at record level. The biggest saving is that DAC can survive during the upgrade , while your custom processes cannot.

    You might also like