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 Overview

Export to PowerCenter Overview

You can export objects from the Developer tool to use in PowerCenter®.
You can export the following objects:
  • Mappings. Export mappings to PowerCenter mappings or mapplets.
  • Mapplets. Export mapplets to PowerCenter mapplets.
  • Logical data object models. Export the logical data object models to PowerCenter mapplets.
You export objects to a PowerCenter repository or to an XML file. If you export objects to an XML file, PowerCenter users can import the file into the PowerCenter repository.
When you export objects, you specify export options such as the PowerCenter release, how to convert mappings and mapplets, and whether to export reference tables.
You can export mappings and mapplets that contain parameters. The parameters resolve to the default values when you import the mappings to the PowerCenter repository.
Use the Developer tool or the required export command to export to PowerCenter to reuse the metadata.
To export data from the Model repository into the PowerCenter repository, complete the following tasks:
  1. Export Model Repository objects to a file using the Developer tool or with the following command:
    infacmd tools ExportObjects
    Or, you can directly run
    infacmd ipc ExportToPC
    to export.
  2. Convert the export file to a PowerCenter file using the following command:
    infacmd ipc ExporttoPC
  3. Import the objects using the PowerCenter or with the following command:
    pmrep importObjects

0 COMMENTS

We’d like to hear from you!