Sharing Mapping Specification Logic > Mapping Specification Export to PowerCenter
  

Mapping Specification Export to PowerCenter

Export a mapping specification to PowerCenter to share the mapping specification logic with a PowerCenter developer. When you export a mapping specification to PowerCenter you can take advantage of capabilities that are exclusive to PowerCenter such as partitioning, web services, and recovery.
When you export a mapping specification to PowerCenter, you can choose to use the target in the mapping specification or select a target that exists in the Model repository.
If you do not select a target in the mapping specification during export, the Analyst tool exports the mapping specification as a mapplet to PowerCenter. The PowerCenter developer can use this mapplet as a source in a mapping and select a target. The developer can create a session, workflow, and connection objects. The developer can run the workflow.
If you select a target in the Model repository during export, the Analyst tool exports the mapping specification as a mapping to PowerCenter. The Analyst tool export process creates a non-reusable session for this mapping in a workflow. Before the developer runs the workflow, the developer must create the connection objects for the sources and the target in the mapping.
When you export a mapping specification to PowerCenter, you can choose to the following export options:
Export to a PowerCenter Repository
You must specify the PowerCenter repository connection properties and the folder in the PowerCenter repository where you want to export the mapping specification. The connection information for sources and target are not exported.
Export to an XML File
If you do not have permissions to export the mapping specification to a PowerCenter repository, you can choose to export the mapping specification to an XML file. You can download the XML file and share it with a PowerCenter developer. The developer can import the XML file into the PowerCenter repository and use the mapping specification logic as a mapplet or mapping.
In the PowerCenter Designer, the mapping specification objects appear in the appropriate node in the folder. For example, the mapping specification target appears in the Targets node.
PowerCenter developers can view descriptions about mapping specification objects after the mapping specification logic is exported to PowerCenter. Viewing descriptions about mapping specification objects enables PowerCenter developers to understand the logical flow of a mapping specification. In PowerCenter, these descriptions appear in the transformation properties or in the descriptions of the ports in a transformation.

PowerCenter Repository Connection Properties

When you export the mapping specification logic to PowerCenter, you must specify connection properties to connect to the PowerCenter repository.
Configure the PowerCenter repository connection properties:
Host Name
PowerCenter domain gateway host name.
Port Number
PowerCenter domain gateway port number.
User Name
Repository user name.
Password
Password for repository user name.
Security Domain
LDAP security domain name, if one exists. Otherwise, enter "Native."
Repository Name
PowerCenter repository name.
Code Page
Repository code page.
PowerCenter Version
Version of the PowerCenter repository.

Exporting a Mapping Specification to PowerCenter

Export the mapping specification logic to a PowerCenter repository or an XML file if you do not have permissions on the PowerCenter repository.
    1. From the Actions menu, select Export.
    The Export wizard appears.
    2. Select PowerCenter.
    3. Click Next.
    4. Choose to export the mapping specification as a mapplet or a mapping to PowerCenter.
    5. Optionally, click Data Preview to preview the target data.
    6. Optionally, click Properties to view the target properties.
    7. Click Next.
    8. Choose to export the mapping specification to an XML file or to a PowerCenter repository.
    9. Enter the export properties.
    10. Click Next.
    11. Optionally, enter another name for the mapping specification.
    12. Optionally, enter a description.
    13. If you chose to export the mapping specification to a PowerCenter repository, select a folder in the PowerCenter repository to export the mapping specification.
    14. Click Finish.
    The Export to PowerCenter process creates a mapplet or mapping based on the target selected during export in the PowerCenter repository. If you choose to export to an XML file, you can download the file and provide it to a Powercenter developer.