Rules and guidelines for dynamic schema handling for mappings
Rules and guidelines for dynamic schema handling for mappings
Consider the following rules and guidelines when you enable dynamic schema change handling:
Updates to the data types
, precision,
and scale are not applicable.
Schema updates that involve a decrease in the precision of the Varchar data type are not applicable.
When you use special characters in a target table column and select
Alter and Apply Changes
, the mapping task fails with an error.
When you use a completely parameterized filter in a field mapping in a Source transformation and select the
Dynamic
option, the
Runtime Options
page does not display the options to refresh the schema.
When you use an SQL override in a Source transformation and select
Alter and Apply Changes
, the mapping task fails with an error.
When you add a field in the source as a primary key and select
Alter and Apply Changes
, the mapping task runs successfully and the field is propagated to target. However, the primary key is not considered.
When you override the source table name or schema name and select the
Alter and Apply Changes
schema change handling option, and if new fields are added to the overridden source table, the mapping runs successfully. However, the Secure Agent does not fetch the newly added fields from the overridden source table.