You can download transformations from the Administration Site, typically under the following circumstances:
If the transformation status is “Migration Required” — you must migrate it to the newer version of the product in the DDW.
If you have deleted a transformation in the DDW — you can download the transformation from the Administration Site and import it into the DDW.
To download a transformation
Click Manage.
The Source Database Hosts pane and the Details pane appear. The hosts associated with the deployed transformations appear in the Source Database Hosts pane.
In the Source Database Hosts pane, expand the host type, and then the host to view the list of source databases.
Select the transformation source associated with the transformation that you want to download.
The Transformation Source pane appears to the right.
In the Transformation Source pane, click the Transformations tab.
Select the check boxes corresponding to the transformations that you want to download.
Click Download.
The transformation is downloaded to the required location as an .xml file. If you download multiple transformations, they are downloaded as a .zip file.