Limitations and considerations

The following limitations apply to the File target endpoint:

• Only the following DDLs are supported: Truncate table, Drop table, Create table, Add Column, Rename Column, Drop Column, and Convert Data Type.
• Full LOB Mode is not supported
• UPDATE and DELETE statements are not supported in Apply Changes replication mode
• Batch optimized apply mode is not supported
• Target lookup is not supported
• The <target folder> parameter cannot include special characters
• When the When source table is altered Apply Changes setting is set to Ignore ALTER, data files will be updated, but metadata files and metadata headers (if defined) will not.

• Source schema and table names cannot contain periods. If they do, you should use a global transformation to remove/replace the periods; otherwise, data loss will occur.

• Database names, schema names, or table names containing slash (/) or backslash (\) characters are 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.