Enabling Incremental Transfer in RAPCache Tables

Enable RAPCache tables for incremental transfer.

Cache-full and interval rules are both incremental transfer types. When a transfer is invoked, any updates or inserts to the table since last transfer are also sent. The table of derived data can continue to have inserts, updates, and deletes performed upon it while data is transferred. Enable a table for incremental transfer before defining a transfer rule for it.

  1. Execute the new FOR TRANSFER clause on the CREATE and ALTER TABLE commands:
  2. To create a new table with incremental transfer enabled, use:
    CREATE TABLE table_name {other clauses as needed}
WITH TRANSFER TABLE ON
  3. To alter an existing table to enable incremental transfer, use:
    ALTER TABLE table_name {other clauses as needed}
SET TRANSFER TABLE ON