Data Processor Transformation Import and Export
You can export a Data Processor transformation as service and run it from a Data Transformation repository. You can also import a Data Transformation service to the Developer tool. When you import a Data Transformation service, the Developer tool creates a Data Processor transformation from the service.
Note: When you import a Data Transformation service to the Model repository, the Developer tool imports the associated schemas to the repository. If you modify the schema in the repository, sometimes the changes do not appear in the transformation schema references. You can close and open the Model repository connection, or close and open the Developer tool to cause the schema changes to appear in the transformation..
Exporting the Data Processor Transformation as a Service
You can export the Data Processor transformation as a Data Transformation service. Export the service to the file system repository of the machine where you want to run the service. You can run the service with PowerCenter®, user-defined applications, or the Data Transformation CM_console command.
1. In the Object Explorer view, right-click the Data Processor transformation you want to export, and select Export.
The Export dialog box appears.
2. Select Informatica > Export Data Processor Transformation and click Next.
The Select page appears.
3. Click Next.
The Select Service Name and Destination Folder page appears.
4. Choose a destination folder:
- - To export the service on the machine that hosts the Developer tool, click Service Folder.
- - To deploy the service on another machine, click Folder. Browse to the \ServiceDB directory on the machine where you want to deploy the service.
5. Click Finish.
Importing Multiple Data Transformation Services
You can import a directory of Data Transformation services from the machine where you saved the directory. When you import Data Transformation services to the Developer Model repository, the Developer tool imports the transformations, schemas and example data with the . cmw files. If you need to import many services, import a directory of services instead of one service at a time.
1. Click File > Import,
The Import dialog box appears.
2. Select InformaticaImport Data Transformation Services (Folder) and click Next.
The Import Data Transformation Service page appears.
3. Browse to the directory that you want to import.
4. Browse to a location in the Repository where you want to save the transformations, then click Finish.
The Developer tool imports the transformations, schemas and example data with the .cmw file.
Importing a Data Transformation Service
You can import a Data Transformation service from the file system repository of the machine where you saved the service. Import a Data Transformation service .cmw file to the Model repository to create a Data Processor transformation. The Developer tool imports the transformation, schemas and example data with the .cmw file.
1. Click File > Import,
The Import dialog box appears.
2. Select Informatica Import Data Transformation Service and click Next.
The Import Data Transformation Service page appears.
3. Browse to the service .cmw file that you want to import.
The Developer tool names the transformation according to the service file name. You can change the name.
4. Browse to a location in the Repository where you want to save the transformation, then click Finish.
The Developer tool imports the transformation, schemas and example data with the .cmw file.
5. To edit the transformation, double-click the transformation in the Object Explorer view.
Exporting a Mapping with a Data Processor Transformation to PowerCenter
When you export a mapping with a Data Processor transformation to PowerCenter, you can export the objects to a local file, and then import the mapping into PowerCenter. Alternatively, you can export the mapping directly into the PowerCenter repository.
1. In the Object Explorer view, select the mapping to export. Right-click and select Export.
The Export dialog box appears.
2. Select Informatica > PowerCenter.
3. Click Next.
The Export to PowerCenter dialog box appears.
4. Select the project.
5. Select the PowerCenter release.
6. Choose the export location, a PowerCenter import XML file or a PowerCenter repository.
7. Specify the export options.
8. Click Next.
The Developer tool prompts you to select the objects to export.
9. Select the objects to export and click Finish.
The Developer tool exports the objects to the location you selected. If you exported the mapping to a location, the Developer tool also exports the Data Processor transformations in the mapping, as services, to a folder at the location that you specified.
10. If you exported the mapping to a PowerCenter repository, the services are exported to the following directory path: %temp%\DTServiceExport2PC\
The export function creates a separate folder for each service with the following name: <date><serviceFullName>
If the transformation includes relational mapping, a folder is created for relational to hierarchical mapping, and a separate folder for hierarchical to relational mapping.
11. Copy the folder or folders with Data Processor transformation services from the local location where you exported the files to the PowerCenter ServiceDB folder.
12. If you exported the mapping to a PowerCenter import XML file, import the mapping to PowerCenter. For more information about how to import an object to PowerCenter, see the PowerCenter 9.6.0 Repository Guide.