Limitations for transformation rules

The following limitations apply to transformation rules:

• Transformations are not supported for columns with Right-to-Left languages.

• By default, transformations cannot be performed on columns that contain special characters (e.g. #, \, /, -) in their name.

  However, such functionality is provided via the Support special characters in column names used in expressions in the task settings. If you intend to enable option, make sure to carefully review the requirements first.

• The only supported transformation for columns that are mapped to BLOB/CLOB data types (by Replicate) is to drop the column on the target.

• Expressions must be written using SQLite syntax only.

• Changing a global transformation value will not reload affected tables automatically. The target must be reloaded manually for the changes to take effect.

  For information on reloading the target, see Using the Run button options.