GoldenGate Sample Records

sample_delete_record.json

{
  "table": "GG.TCUSTORD",
  "op_type": "D",
  "op_ts": "2013-06-02 22:14:41.000000",
  "current_ts": "2015-09-18T10:17:49.899000",
  "pos": "00000000000000004338",
  "primary_keys": [
    "CUST_CODE",
    "ORDER_DATE",
    "PRODUCT_CODE",
    "ORDER_ID"
  ],
  "tokens": {
    "6": "9.0.80330",
    "L": "206080450",
    "R": "AADPkvAAEAAEqLzAAC"
  },
  "before": {
    "CUST_CODE": "DAVE",
    "CUST_CODE_isMissing": false,
    "ORDER_DATE": "1993-11-03:07:51:35",
    "ORDER_DATE_isMissing": false,
    "PRODUCT_CODE": "PLANE",
    "PRODUCT_CODE_isMissing": false,
    "ORDER_ID": "600",
    "ORDER_ID_isMissing": false,
    "PRODUCT_PRICE": null,
    "PRODUCT_PRICE_isMissing": true,
    "PRODUCT_AMOUNT": null,
    "PRODUCT_AMOUNT_isMissing": true,
    "TRANSACTION_ID": null,
    "TRANSACTION_ID_isMissing": true
  },
  "after": null
}

sample_insert_record.json

{
  "table": "GG.TCUSTORD",
  "op_type": "I",
  "op_ts": "2013-06-02 22:14:36.000000",
  "current_ts": "2015-09-18T10:17:49.570000",
  "pos": "00000000000000001444",
  "primary_keys": [
    "CUST_CODE",
    "ORDER_DATE",
    "PRODUCT_CODE",
    "ORDER_ID"
  ],
  "tokens": {
    "R": "AADPkvAAEAAEqL2AAA"
  },
  "before": null,
  "after": {
    "CUST_CODE": "WILL",
    "CUST_CODE_isMissing": false,
    "ORDER_DATE": "1994-09-30:15:33:00",
    "ORDER_DATE_isMissing": false,
    "PRODUCT_CODE": "CAR",
    "PRODUCT_CODE_isMissing": false,
    "ORDER_ID": "144",
    "ORDER_ID_isMissing": false,
    "PRODUCT_PRICE": 17520,
    "PRODUCT_PRICE_isMissing": false,
    "PRODUCT_AMOUNT": 3,
    "PRODUCT_AMOUNT_isMissing": false,
    "TRANSACTION_ID": "100",
    "TRANSACTION_ID_isMissing": false
  }
}

sample_update_record.json

{
  "table": "GG.TCUSTORD",
  "op_type": "U",
  "op_ts": "2013-06-02 22:14:41.000000",
  "current_ts": "2015-09-18T10:17:49.880000",
  "pos": "00000000000000002891",
  "primary_keys": [
    "CUST_CODE",
    "ORDER_DATE",
    "PRODUCT_CODE",
    "ORDER_ID"
  ],
  "tokens": {
    "R": "AADPkvAAEAAEqLzAAA"
  },
  "before": {
    "CUST_CODE": "BILL",
    "CUST_CODE_isMissing": false,
    "ORDER_DATE": "1995-12-31:15:00:00",
    "ORDER_DATE_isMissing": false,
    "PRODUCT_CODE": "CAR",
    "PRODUCT_CODE_isMissing": false,
    "ORDER_ID": "765",
    "ORDER_ID_isMissing": false,
    "PRODUCT_PRICE": 15000,
    "PRODUCT_PRICE_isMissing": false,
    "PRODUCT_AMOUNT": 3,
    "PRODUCT_AMOUNT_isMissing": false,
    "TRANSACTION_ID": "100",
    "TRANSACTION_ID_isMissing": false
  },
  "after": {
    "CUST_CODE": "BILL",
    "CUST_CODE_isMissing": false,
    "ORDER_DATE": "1995-12-31:15:00:00",
    "ORDER_DATE_isMissing": false,
    "PRODUCT_CODE": "CAR",
    "PRODUCT_CODE_isMissing": false,
    "ORDER_ID": "765",
    "ORDER_ID_isMissing": false,
    "PRODUCT_PRICE": 14000,
    "PRODUCT_PRICE_isMissing": false,
    "PRODUCT_AMOUNT": 3,
    "PRODUCT_AMOUNT_isMissing": false,
    "TRANSACTION_ID": "100",
    "TRANSACTION_ID_isMissing": false
  }
}