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

Dynamic Mapping Ports and Links

Dynamic Mapping Ports and Links

In order to process changes in metadata, you can configure port and link types that a regular mapping does not contain.
The following image shows the ports and links that you can see in a dynamic mapping:
The mapping contains a Read transformation, Sorter transformation, and a Write transformation. The transformations include groups and ports. The Sorter transformation includes a dynamic port and generated ports. The mapping contains links between ports and a run-time link between the groups of Sorter and Write transformations.
  1. Static port (port)
  2. Dynamic port
  3. Generated port
  4. Design-time link (link)
  5. Run-time link
  6. Port Group
Static port (port)
A port that you can create in any type of mapping, dynamic or non-dynamic. Data can pass in to and out of the port and does not contain any dynamic configuration.
Dynamic port
A port in a transformation that can receive one or more columns from an upstream transformation. Dynamic ports can receive new or changed columns based on the metadata that passes through the mapping.
Generated port
A port that represents a single column within a dynamic port. The dynamic port creates a generated port for each column based on the dynamic port rules.
Design-time link (link)
A link that you create to connects ports that propagate data from one transformation to another. You also create these links in a regular mapping.
Run-time link
A link between transformation groups that the Data Integration Service uses to determine which ports to connect at run time based on a policy, a parameter, or both.
Port group
A set of ports in a mapping that represents a row of data. In a dynamic mapping, you can drag a group to a downstream transformation to create a dynamic port.

0 COMMENTS

We’d like to hear from you!