When you create a mapping, the transformation palette displays the available transformations. The transformations that are available differ depending on whether you are using
advanced mode or
SQL ELT mode.
When you copy a transformation into a mapping, the
Validation
panel shows validation errors if a transformation is available only in advanced mode. To resolve the errors, update the data logic in the mapping to use only the available transformations.