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

Import from PowerCenter Overview

Import from PowerCenter Overview

You can import objects from a PowerCenter repository to a Model repository. The import process validates and converts PowerCenter repository objects to Model repository objects and imports them.
Before you import objects from PowerCenter, run the infacmd ipc genReuseReportfromPC command in the command line to estimate the number of PowerCenter mappings that you can reuse in the Model repository in the native and Hadoop environments.
When you import objects from PowerCenter, you select the objects that you want to import and the target location in the Model repository. The import process provides options to resolve object name conflicts during the import.
You can also choose to assign connections in the Model repository to the PowerCenter objects. You can assign a single connection to multiple PowerCenter objects at the same time.
You can import mappings that contain parameters. When you import a mapping with reusable transformations, the import process imports the PowerCenter mapping parameters and generates the transformation-level parameters to bind them to. If the mapping has nonreusable transformations, the input process creates the parameters at the mapping level.
You can import mappings from PowerCenter to reuse the metadata. Use the Developer tool or the required import command to import from PowerCenter.
To import data from PowerCenter into the Model Repository, complete the following tasks:
  1. Export PowerCenter objects to a file using the PowerCenter Client or with the following command:
    pmrep ExportObject
  2. Convert the export file to a Model repository file using the following command:
    infacmd ipc importFromPC
  3. Import the objects using the Developer tool or with the following command:
    infacmd tools importObjects
You can import mappings with multiple pipelines, sessions, workflows, worklets from PowerCenter into the Model repository. Sessions within a workflow are imported as Mapping tasks in the Model repository. Workflows are imported as workflows within the Model repository. Worklets within a workflow are expanded and objects are imported into the Model repository.
After the import process completes, you can view the import summary.

0 COMMENTS

We’d like to hear from you!