Table of Contents

Search

  1. Preface
  2. PowerExchange CDC Publisher Overview
  3. Installing and Upgrading PowerExchange CDC Publisher
  4. PowerExchange CDC Publisher Key Concepts
  5. PowerExchange Change Capture Environment
  6. Target Messaging Systems
  7. Configuring PowerExchange CDC Publisher
  8. Streaming Change Data
  9. Monitoring PowerExchange CDC Publisher
  10. Administering PowerExchange CDC Publisher
  11. Appendix A: Command Reference for the Command-Line Utilities
  12. Appendix B: Avro Schema Formats
  13. Appendix C: Custom Pattern Formats
  14. Appendix D: Message Reference

User Guide

User Guide

Avro Flat Schema Format

Avro Flat Schema Format

An Avro schema that uses the flat format contains all of the Avro column-definition fields in one Avro record. The schema is specific to the source object that contains the defined columns.
The following flat schema defines two columns in one record:
{"type" : "record", fields" : [ { {"name" : "COL1", "type" : [ "null", "string" ], "doc" : "...", "default" : null} {"name" : "COL1_Present", "type" : "boolean", "doc" : …} {"name" : "COL1_BeforeImage", "type" : [ "null", "string" ],"doc" : … } {"name" : "COL1_BeforeImage_Present", "type" : "boolean", "doc" : …} {"name" : "COL2", "type" : [ "null", "string" ], "doc" : "...", "default" : null} {"name" : "COL2_Present", "type" : "boolean", "doc" : …} {"name" : "COL2_BeforeImage", "type" : [ "null", "string" ],"doc" : … } {"name" : "COL2_BeforeImage_Present", "type" : "boolean", "doc" : …} }]

0 COMMENTS

We’d like to hear from you!