The following table lists the transformation, object type, and the fields in the advanced properties of a mapping that you can retain when you migrate to the new environment:
Single object, multiple objects
Applicable for unconnected, and connected cached and uncached.
Before you migrate a mapping to Org2, map the connection1 of Org1 to Org2 that can access the schema and table name configured in the advanced properties in Org1.
After you migrate the mapping to Org2, you must not edit the mapping.
When you override the schema and table name in a mapping, the mapping fails with an error if the schema used in the connection in Org2 is not valid. The mapping fails with the following error:
An unexpected exception occured while fetching metadata:[The following schema is not found - invalidschema]
You cannot dynamically refresh the data object schema at runtime. You must maintain the same metadata for the table selected in the source, target, or lookup transformations and the corresponding advanced field overrides as schema change handling is not applicable.
Do not specify an SQL override in the mapping. Otherwise, the mapping fails to run.
Consider the following guidelines for multiple sources:
If the mapping contains multiple sources, you can override the schema in the advanced properties only if the source objects have the same schema, as in the following example:
If the schema is different, for example, if the schema for object1 is
and object2 is
, migration does not work.
Do not override the table from the advanced properties if the mapping contains multiple objects.