Configuring High-Speed Transfer of Derived Data

Set up transfer and truncation of derived data in the RAPCache and RAPStore.

1. To set up data truncation:
   • For efficient deletion, include an index on the column that is used to determine whether data is old. For example, add an index to the date-time column, or a time column.
2. To set up data transfer:
   • Ensure the code page for the Adaptive Server Enterprise database matches the code page used for Sybase IQ.
   • Ensure the Adaptive Server Enterprise and IQ tables have the same number of columns, with the same names.
   • Ensure the column types in Adaptive Server Enterprise and IQ are compatible according to the Adaptive Server Enterprise and IQ data mapping types.
   • The data transfer facility does not automatically maintain dependencies across tables. Define transfer rules to accommodate transfers of all dependent data.

• Data Transfer and Truncation Restrictions
  There are certain restrictions for truncations and transfers.