Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapplets
  4. Mapping Parameters
  5. Mapping Outputs
  6. Generate a Mapping from an SQL Query
  7. Dynamic Mappings
  8. How to Develop and Run a Dynamic Mapping
  9. Dynamic Mapping Use Cases
  10. Mapping Administration
  11. Export to PowerCenter
  12. Import From PowerCenter
  13. Performance Tuning
  14. Pushdown Optimization
  15. Partitioned Mappings
  16. 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!