OWB - Change Data Capture

Card Puncher Data Processing

OWB - Change Data Capture


The implemention in OWB of Change Data Capture is made through the Change Data Capture capabilities of the Oracle Database : ORACLE - Streams / Change Data Capture.

With at least the first release of OWB10gR2, the setting up of Asynchronous Change Data Capture takes place mostly outside of the tool. What you can then do is use OWB “Paris” to pick up the changed data when it arrives at the target data warehouse, and use the Change Data Capture PL/SQL API to request updated data (referred to as “extending the subscription window”), and then mark it as read after it’s loaded (known as “purging the subscription window”).

Documentation / Reference

Discover More
Card Puncher Data Processing
Oracle Warehouse Builder

Owb Documentation - Understanding Data Quality Management White...

Share this page:
Follow us:
Task Runner