Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapplets
  4. Mapping Parameters
  5. Where to Assign Parameters
  6. Mapping Outputs
  7. Generate a Mapping from an SQL Query
  8. Dynamic Mappings
  9. How to Develop and Run a Dynamic Mapping
  10. Dynamic Mapping Use Cases
  11. Mapping Administration
  12. Export to PowerCenter
  13. Import From PowerCenter
  14. Performance Tuning
  15. Pushdown Optimization
  16. Partitioned Mappings
  17. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping Guide

Export to PowerCenter Options

Export to PowerCenter Options

When you export an object for use in PowerCenter, you must specify the export options.
The following table describes the export options:
Option
Description
Project
Project in the Model repository from which to export objects.
Target release
PowerCenter release version.
Export selected objects to file
Exports objects to a PowerCenter XML file. If you select this option, specify the name and location of the export XML file.
Export selected objects to PowerCenter repository
Exports objects to a PowerCenter repository. If you select this option, specify the following connection details for the PowerCenter repository:
  • Host name. PowerCenter domain gateway host name.
  • Port number. HTTP port number of the PowerCenter domain gateway.
  • Authentication type. Select one of the following values: Kerberos Single Sign On, Native, or LDAP.
  • User name. Repository user name.
  • Password. Password for the repository user name.
    Specify the user name and password if the authentication type is Native or LDAP.
  • Security domain. If the authentication type is LDAP, specify the LDAP security domain name. Otherwise, enter "Native."
  • Repository name. PowerCenter repository name.
Send to repository folder
Exports objects to the specified folder in the PowerCenter repository.
Use control file
Exports objects to the PowerCenter repository using the specified
pmrep
control file.
Convert exported mappings to PowerCenter mapplets
Converts Developer tool mappings to PowerCenter mapplets.
The Developer tool converts data objects used as sources and targets in the mappings to Input and Output transformations in a PowerCenter mapplet.
Convert target mapplets
Converts data objects used as targets in mapplets to Output transformations in the PowerCenter mapplet.
PowerCenter mapplets cannot contain targets. The export process fails if the export object includes a mapplet that contains a target and you do not select this option.
Export reference data
Exports any reference table data used by a transformation in an object you export.
Reference data location
Location for the reference table data that the Developer tool exports. The Developer tool exports the reference table data as one or more dictionary files. Enter a path to a directory on the machine that hosts the Developer tool.
Code page
Code page of the PowerCenter repository.

0 COMMENTS

We’d like to hear from you!