You can import a transformation that was previously created in DDW and exported to an XML file by using the import feature.
You can import a transformation
To update the transformation in the current repository.
To reuse the mappings in the transformation and import as a new transformation in the current repository.
Data Exchange uses an internal ID to uniquely identify a transformation. Also, each transformation must have a unique name in the same DDW Repository. While importing a transformation, there might be ID and name conflicts. DDW provides warnings and enables you to resolve these conflicts as you import the transformation.
To import the transformation
On the Transformation menu, click Import Transformation.
The Import Transformation dialog box appears.
Browse to the location where the transformation XML file is saved, and select the file to import.
Click OK
If the file you chose has no conflicts with transformation ID and transformation name, the selected file is imported to the DDW repository.