OWB - Change Data Capture

> Data Integration Tool (ETL/ELT) > Oracle Warehouse Builder

1 - About

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”).

3 - Documentation / Reference