Informatica Tutorials

Big Data Analytics

Advantages of Change Data Capture

The following list describes the advantages of capturing change data with Change
Data Capture:

■ Completeness
Change Data Capture can capture all effects of INSERT, UPDATE, and DELETE
operations, including data values before and after UPDATE operations.
■ Performance
Asynchronous Change Data Capture can be configured to have minimal
performance impact on the source database.
■ Interface
Change Data Capture includes the DBMS_CDC_PUBLISH and DBMS_CDC_
SUBSCRIBE packages, which provide easy-to-use publish and subscribe
interfaces.
■ Cost
Change Data Capture reduces overhead cost because it simplifies the extraction of
change data from the database and is part of Oracle9i Database and later
databases.

Note that you cannot use any table that uses transparent data encryption as a source
table for Change Data Capture.
A Change Data Capture system is based on the interaction of publishers and
subscribers to capture and distribute change data, as described in the next section.

Related Posts Plugin for WordPress, Blogger...

Please Share

Twitter Delicious Facebook Digg Stumbleupon Favorites More

 
Follow TutorialBlogs
Share on Facebook
Tweet this Blog
Add Blog to Technorati
Home