The source fields must start with a letter or an underscore and can contain letters, numbers, and underscores up to a maximum of 300 characters. You cannot read source fields with special characters.

When you read a boolean integer column and write to a boolean string column in a mapping, the mapping fails.

When you write data with the Numeric data types to a Google BigQuery target created at runtime, where the source column has precision greater than 28, the mapping runs without

SQL ELT optimization

.

When you set the JVM option system property for the DTM type to

-DHonorInfaDateFormat=true

for the Secure Agent and configure a mapping with

SQL ELT optimization

, the mapping fails with the following error if it reads the date data type that is not in the YYYY-MM-DD format:

When you map a string data type in the source to a time data type in the target, and the data is in the format HH24:MI:SS.US, the mapping fails with the following error: