Limitations and considerations

When working with a CDP Private Cloud endpoint, bear in mind the following limitations and considerations:

• Table and column names can only contain ASCII characters.
• Column names cannot contain the '?' symbol. If needed, the '?' symbol can be replaced with a valid ASCII character using a transformation.

• Limited LOB size support only (LOB size will be limited to the maximum STRING size available on CDP Private Cloud).
• DDL Limitations:
  • Changing column data types or the data type length is not supported. Changing the columns data type will suspend the table and changing the data type length will simply be ignored

  • The DROP COLUMN DDL is not supported. Dropping a column during Change Capture will set NULL values in the target column position on subsequent INSERTs or UPDATEs.

• DDL limitations and considerations when the "Apply Changes DDL Handling Policy" is set to "Ignore" (Ignore DDL changes):

  • Renaming a table is not supported and will result in the table being suspended (if the Table Error handling policy is "Suspend Table", which is the default).

  • Renaming a column is not supported. Renaming a column during Change Capture will set NULL values in the target column position on subsequent INSERTs or UPDATEs.

  • Deleting a source column will set NULLs in the corresponding target column.
  • Modifications to a source column will be ignored, but may cause unpredictable behavior (for instance, when a data type is modified).

• The creation of skews, buckets or partitions in the target tables (or their preexistence in the target tables) is not supported.

• The following Control Tables are not supported as they require UPDATE/DELETE operations, which are not supported:

  • Replication Status (requires UPDATE).

    Name on target: attrep_status

  • Suspended Tables (requires DELETE).

    Name on target: attrep_suspended_tables

    For more information on Control Tables, see Control tables.

• The Store task recovery data in target database Advanced Run option is not supported

• The Batch optimized apply Change Processing mode is not supported.