Table of Contents

Search

  1. Preface
  2. Part 1: PowerExchange CDC Introduction
  3. Part 2: PowerExchange CDC Components
  4. Part 3: PowerExchange CDC Data Sources
  5. Part 4: Change Data Extraction
  6. Part 5: Monitoring and Tuning
  7. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Event Table Processing

Event Table Processing

Use event table processing to stop the extraction of changes based on user-defined events, such as an end-of-day event.
For example, to stop an extraction process every night, after all changes for the day are processed, write a change to the event table at midnight. This change triggers PowerExchange to stop reading change data and shut down the extraction process after the current UOW completes.
Use the following rules and guidelines:
  • You can use event table processing only with real-time or continuous extraction modes.
  • You must create the event table and define the applications that can update the table.
  • You must register the event table for change data capture from the PowerExchange Navigator.
  • A CDC session monitors a single event table. Each user-defined event requires its own event table and a separate extraction process.
  • The event table and all of the source tables in the CDC session must be of the same source type.

0 COMMENTS

We’d like to hear from you!