Table of Contents

Search

Data Transformation Getting Started Guide

Data Transformation Getting Started Guide

Step 1. Export the Mapping to PowerCenter

Step 1. Export the Mapping to PowerCenter

Export a mapping to the PowerCenter repository.
  1. In the
    Object Explorer
    view, select the mapping to export. Right-click and select
    Export
    .
    The
    Export
    dialog box appears.
  2. Select
    Informatica
    PowerCenter
    .
  3. Click
    Next
    .
    The
    Export to PowerCenter
    dialog box appears.
  4. Select the project.
  5. Select the PowerCenter release.
  6. Choose to export to the PowerCenter repository.
  7. Specify the export options.
  8. Click
    Next
    .
    The Developer tool prompts you to select the objects to export.
  9. Select the objects to export and click
    Finish
    .
  10. When you exported the mapping to a PowerCenter repository, the services are exported to the following directory path:
    %temp%\DTServiceExport2PC\
    The export function creates a separate folder for each service with the following name:
    <date><serviceFullName>
    When the transformation includes relational mapping, a separate folder is created for the relational to hierarchical mapping.
  11. Copy the folder or folders with Data Processor transformation services from the local location
    %temp%\DTServiceExport2PC\
    to the PowerCenter ServiceDB folder.
  12. If the mapping contains data object flat files, copy the source files from the server location, such as
    C:\tmp
    , to the PowerCenter machine folder
    <INSTALL_DIR>\server\infa_shared\SrcFiles
    .
  13. To view the mapping, refresh the repository in the PowerCenter Repository Manager. Select the repository, right-click and select
    Disconnect
    , then right-click and select
    Connect
    .