3 Replies Latest reply: Jul 18, 2013 4:00 PM by Hussein Sawwan-Oracle RSS

    EBS to DWH Extract

    Muthu Sakthi

      Hi,


      We are implementing R12.1.3 of Ebusiness Suite and will be using the Finacial modules and HRMS modules.

      We have been requested to provide extract on a daily basis to the DWH application on an incremental basis.

       

      Our Idea is to have a concurrent request that will fetch data from the tables and populate tables in a staging area

      based on the last_update_date column in each table. Right now we have identified close to 250 odd tables and this list

      will grow as we identify more tables.

       

      I understand the above will have a huge performance issue and will use a lot of resources.

       

      I would like to know if there is a better approach to this.

       

      Thanks,

      Muthu.