Ask Your Question

Revision history [back]

The record header attribute sdc.operation.type is set according to the CDC operation:

  • 1 for INSERT records
  • 2 for DELETE records
  • 3 for UPDATE records
  • 4 for UPSERT records
  • 5 for unsupported operations or codes
  • 6 for UNDELETE records
  • 7 for REPLACE records
  • 8 for MERGE records

You can use an Expression Evaluator to always set sdc.operation.type to 1, so the record is inserted into the target table:

image description