Scribd Logo
Upload

Welcome to Scribd!

  • 42 views

    Class4 Rahul

    Uploaded by

    Rahul Reddy
    DAC (Data Warehouse Application Console) works with Informatica to accomplish ETL for pre-packaged BI applications. It publishes changes from OLTP systems and manages performance by dropping indexes and rebuilding them during the ETL process. Without DAC, a custom change capture process would need to be written and a new ETL method designed to restart from point of failure at the record level. DAC also serves as a metadata-driven administration tool that enables parallel loading for high performance ETL and change capture from Siebel OLTP systems.

    Copyright:

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

    Class4 Rahul

    Uploaded by

    Rahul Reddy
    42 views2 pages
    DAC (Data Warehouse Application Console) works with Informatica to accomplish ETL for pre-packaged BI applications. It publishes changes from OLTP systems and manages performance by dropping indexes and rebuilding them during the ETL process. Without DAC, a custom change capture process would need to be written and a new ETL method designed to restart from point of failure at the record level. DAC also serves as a metadata-driven administration tool that enables parallel loading for high performance ETL and change capture from Siebel OLTP systems.

    Original Title

    class4.rahul

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    DAC (Data Warehouse Application Console) works with Informatica to accomplish ETL for pre-packaged BI applications. It publishes changes from OLTP systems and manages performance by dropping indexes and rebuilding them during the ETL process. Without DAC, a custom change capture process would need to be written and a new ETL method designed to restart from point of failure at the record level. DAC also serves as a metadata-driven administration tool that enables parallel loading for high performance ETL and change capture from Siebel OLTP systems.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    42 views2 pages

    Class4 Rahul

    Uploaded by

    Rahul Reddy
    DAC (Data Warehouse Application Console) works with Informatica to accomplish ETL for pre-packaged BI applications. It publishes changes from OLTP systems and manages performance by dropping indexes and rebuilding them during the ETL process. Without DAC, a custom change capture process would need to be written and a new ETL method designed to restart from point of failure at the record level. DAC also serves as a metadata-driven administration tool that enables parallel loading for high performance ETL and change capture from Siebel OLTP systems.

    Copyright:

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

    Downloaded from a website……

    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.

    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

    You might also like