Table of Contents


  1. Preface
  2. Introduction to Data Transformation
  3. Data Processor Transformation
  4. Wizard Input and Output Formats
  5. Relational Input and Output
  6. Using the IntelliScript Editor
  7. XMap
  8. Libraries
  9. Schema Object
  10. Command Line Interface
  11. Scripts
  12. Parsers
  13. Script Ports
  14. Document Processors
  15. Formats
  16. Data Holders
  17. Anchors
  18. Transformers
  19. Actions
  20. Serializers
  21. Mappers
  22. Locators, Keys, and Indexing
  23. Streamers
  24. Validators, Notifications, and Failure Handling
  25. Validation Rules
  26. Custom Script Components

Exporting a Mapping with a Data Processor Transformation to PowerCenter

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
    dialog box appears.
  2. Select
  3. Click
    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
    The Developer tool prompts you to select the objects to export.
  9. Select the objects to export and click
    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:
    The export function creates a separate folder for each service with the following name:
    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

Updated March 18, 2021