After changing a Re-usable Transformation, a dialog appears asking to confirm that changes should be applied to individual columns using the transformation, where possible:

If the Re-usable Transformation doesn't have any dependant columns, then the following message is displayed:

If the Re-usable Transformation has been used for dependant columns then this message is displayed:

When an attempt is made to update a dependant Transformation, and the transformation has been modified in such a way as to make it impossible for the changes to the Re-usable Transformation to be applied, the error message above will include a count of the failures. The Results pane will detail the columns (and tables) where the update failures have occurred:

  • No labels