To change a re-usable transformation:

  1. Select Re-Usable Transformations from the Tools menu.
  2. Choose the transformation from the Transform Name drop-down list.
  3. Click on the Model Tab.
  4. Change the SQL as required. 
  5. Click OK.

Example of a change to the Model SQL

In the example used in Creating a New Re-usable Transformation, the SQL was:

TO_DATE(RTRIM(string_column ),'YYYYMMDD')

Change the SQL to allow the format to be specified when the transformation is used by changing YYYYMMDD to format.

Then highlight the word format and click on the Variable button. This makes the word format a variable than can be substituted when the Re-usable Transformation is used.

Now format is green and in italics:

Click OK.

  • No labels