When a source object consists of Date data type and you use the default create target option in a mapping, the date data gets corrupted. To resolve this issue, navigate to

Edit Metadata

option in the

Target fields

of the target and change

Native Type

to Date.

When you enable dynamic schema handling in a task and create target at runtime, you must provide the complete path of the target table in the Database Name. Ensure that the table name is in lowercase. For example, database_name/TABLE/table_name.

When you configure a mapping to create a new target at runtime and the source data contains complex fields, the metadata fails to appear on the

Target Fields

tab.

Hierarchical data types are supported only when you create a new target at runtime and not for existing targets.

Only

Insert

operation is applicable for hierarchical data types in the Target transformation