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.
I would suggest Active Data Guard.
Using Active Data Guard Reporting with Oracle E-Business Suite Release 12.1 and Oracle Database 11g [ID 1070491.1]
Question on Active Data Guard Reporting With EBS R12.1 [ID 1451500.1]
Business Continuity for Oracle E-Business Release 12 Using Oracle 11g Release 2 and later Physical Standby Database [ID 1070033.1]