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.