In advanced mode, the transformation palette displays the transformations that enable advanced functionality. When you copy a mapping to advanced mode, you might need to update the data flow to use the available transformations.
When you copy a mapping to advanced mode, the
Validation
panel shows validation errors if a transformation is not available in advanced mode. To resolve the errors, update the data logic in the mapping to use only the transformations that are available in advanced mode. Transformations in advanced mode might behave differently.
The following transformations are available in advanced mode: