Mapping dynamic columns
It is easy to map dynamic columns in the tMap component, as in the Map Editor, simply dropping the dynamic column from the input schema to the output schema does not change any of the column values:
However, certain limitations must be respected:
- The dynamic column must be mapped on a one to one basis and cannot undergo any transformations.
- The dynamic column cannot be used in filter expressions or in variables.
- The dynamic column cannot be renamed in output tables and cannot be used as a join condition.
Information noteNote: Dynamic schemas can be mapped to several outputs and can also be mapped
from lookup inputs.