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

Exporting an Object to PowerCenter

Exporting an Object to PowerCenter

When you export mappings, mapplets, or logical data object models to PowerCenter, you can export the objects to a file or to the PowerCenter repository.
Before you export an object, set the compatibility level to the appropriate PowerCenter release. Validate the object to verify that it is compatible with the PowerCenter release.
  1. Click
    File
    Export
    .
    The
    Export
    dialog box appears.
  2. Select
    Informatica
    PowerCenter
    .
  3. Click
    Next
    .
    The
    Export to PowerCenter
    dialog box appears.
  4. Select the project in the Model repository from which you want to export objects.
  5. Select the PowerCenter release to which you want to export the objects.
  6. Choose the location where you want to export the objects. You can export the objects to an XML file of the a PowerCenter repository.
    • To export objects to a file, specify the name and location of an XML file.
    • To export objects to a PowerCenter repository, click
      Browse
      to specify the connection details to the repository.
  7. If you export to a PowerCenter repository, select a folder in the PowerCenter repository or the
    pmrep
    control file that defines how to import objects into PowerCenter.
  8. Select
    Convert exported mappings to PowerCenter mapplets
    to convert the Developer tool mappings to mapplets in PowerCenter.
  9. Select
    Convert Target mapplets
    to convert data objects used as targets in a mapplet to Output transformations in the PowerCenter mapplet.
  10. Select
    Export Reference Data
    to export any reference table data used by a transformation in an object you export.
  11. If want to export the reference data, specify the location for the reference table data that the Developer tool exports.
  12. Select the code page of the PowerCenter repository.
  13. Click
    Next
    .
    The Developer tool prompts you to select the objects to export.
  14. Select the objects to export and click
    Finish
    .
    The Developer tool exports the objects to the location you selected.
If you export objects to a file, you can import objects from the file into the PowerCenter repository.
If you export reference table data, copy the reference data files to the PowerCenter directory structure on the machine that hosts Informatica services. The reference data file locations must correspond to the reference table object locations in the Model repository.
For example, copy the reference data files to the following location:
<PowerCenter installation directory>\services\<Model repository project name>\<Folder name>

0 COMMENTS

We’d like to hear from you!