Change Data Capture in ODI
351180Jan 3 2008 — edited Sep 28 2010Hi all,
A client of ours is planning to replicate their production database into a reporting database. All tables will be copied to the reporting DB. They also need to do "Change Data Capture" on the production DB and reflect the changes into the reporting DB in real time. Since the production DB is from a transaction system, the changes will be quite big. They are worried about the performance of the production DB during the copy process. Is Oracle Data Integrator capable in doing this? They are running Oracle 9.2 on Windows platform. Thank you.
Regards,
Gerd