An expression in a transformation must contain 4,000 characters or fewer.

The database type for an SQL transformation converts to ODBC during the import process.

When you set the data cache size or the index cache size for a transformation to a value that is not valid, the import process changes the value to Auto.

When you import a mapping with an empty Lookup cache directory name into the Model repository, the imported mapping is not valid. To resolve this issue, enter a valid value for the Lookup cache directory name under the run-time properties for the Lookup transformation in the Developer tool.