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

Connecting Mapping Objects

Connecting Mapping Objects

Complete a mapping by connecting the mapping objects. You connect mapping objects through the ports. Data passes into and out of a transformation through input ports, output ports, and input/output ports.
When you add an object to a mapping, you connect the properties according to how you want the Data Integration Service to transform the data. The editor displays mapping objects in the following ways:
  • Iconized. Shows an icon of the object with the object name.
    The following image shows a mapping with iconized objects:
    This image shows three icon versions of objects in a mapping. The first object is an Expression transformation, the second object is a Sorter transformation, and the third object is a write transformation. The metadata is not displayed in this view.
  • Normal. Shows the columns and the input and output port indicators. You can connect objects that are in the normal view.
    The following image shows the preceding iconized mapping in normal view:
    This image shows the normal view of the previous mapping. The metadata is displayed and visible in this version.
When you link ports between input objects, transformations, mapplets, and output objects, you can create the following types of links:
  • One to one links. Link one port in an input object to one port in an output object.
  • One to many links. Link one port to multiple output objects. You can also link multiple ports in one object to multiple output objects.
You can manually link ports or link ports automatically:
  • Manually linking ports. You can manually link one port or multiple ports. Drag a port from an input object to the port of an output object.
  • Automatically linking ports. When you link ports automatically, you can link by position or by name.
For more information about linking ports, see the
Developer Transformation Guide
.

0 COMMENTS

We’d like to hear from you!