A transformation can be exported from a DDW session as an XML file, and can be imported and used in another DDW session.
Click the Transformation View.
Select the transformation that you want to export.
On the Transformation menu, click Export Transformation.
The Export Transformation dialog box appears.
Select the required location, enter the file name in the File name field, and click Save.
The transformation is saved in an XML format.
You can click Cancel to cancel the process.