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. Import From PowerCenter
  13. Performance Tuning
  14. Pushdown Optimization
  15. Partitioned Mappings
  16. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping Guide

Restore Source Port Names

Restore Source Port Names

You can restore source port names when you rename generated ports.
For example, you can rename generated ports to add a prefix
Pre_
to all of the ports in one transformation in the mapping flow. In a downstream transformation, you can restore the source port names to restore the name before the prefix was added. When you restore the source port names, the Developer tool restores the port names as they appear in the nearest upstream transformation with static ports.
The following image shows an Expression transformation where the generated ports are renamed with a prefix
Pre_
:
This image shows a mapping with a Read transformation and a downstream Expression transformation. All of the Read transformation ports are linked to the Expression transformation. The ports are renamed with a prefix Pre_ in the Expression transformation.
The following image shows a Filter transformation where the source port names are restored:
This image shows a mapping with a Read transformation and downstream Expression and Filter transformations. All of the Read transformation ports are linked to the Expression transformation and all of the Expression transformation ports are linked to the Filter transformation. The ports are renamed with a prefix Pre_ in the Expression transformation. The ports do not have the prefix Pre_ in the Filter transformation. In the Filter transformation, the port names appear as they are in the upstream Read transformation.
The port names are restored according to the upstream Read transformation that contains static ports.

0 COMMENTS

We’d like to hear from you!