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

SAP HANA CDC Log Tables

SAP HANA CDC Log Tables

The extraction process uses the following log tables to record change data:
  • The PKLOG transaction log table contains the captured inserts, updates, and deletes, along with associated metadata.
  • The PROCESSED log table contains the current maximum sequence number for the most recent extraction cycle.
  • PowerExchaange creates a CDC table for each source table registered with the Full Audit option. The CDC tables contain the following information:
    • before images of updated rows
    • captured inserts, updates and delete
    • associated metadata for the source tables

0 COMMENTS

We’d like to hear from you!