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

Link Resolution

Link Resolution

Generated ports within a dynamic port can change based on the dynamic source or on input rules.
If you create a link from a generated port and the generated port is no longer available, the Developer tool shows the link to the port as an unresolved link.
For example, you update the input rule for the "From_Read_EMPLOYEE" dynamic port in the Sorter transformation to exclude the "name" port. The Developer tool changes the link to an unresolved link.
The following image shows an unresolved link to the port "name" in the Expression transformation:
The mapping contains a Read transformation, Sorter, and an Expression transformation. The Sorter transformation has a dynamic port "From_Read_EMPLOYEE" and two ports ssn and zip5. The dynamic ports From_Read_EMPLOYEE are linked between the Sorter and Expression transformations. The generated port "name" in the Sorter transformation is no longer available. The link to the port "name" in the Expression transformation appears unresolved. The ports ssn and zip5 are linked between the Sorter and Expression transformations.
The Developer tool shows a warning message for unresolved links when you validate the mapping. If the generated port is available when you run the mapping, the Data Integration Service resolves the link and processes the mapping. However, if the Data Integration Service cannot resolve the link, the mapping fails. You must remove the unresolved links to successfully run the mapping. Right-click the transformation and select
Clear Unresolved Links
to clear any unresolved links in a transformation.

0 COMMENTS

We’d like to hear from you!