Table of Contents


  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Datatype Reference
  17. Configure the Web Browser

Connecting Mapping Objects

Connecting Mapping Objects

After you add and configure source, target, and transformation objects in a mapping, complete the mapping by connecting the mapping objects. You connect mapping objects through the ports. Data passes into and out of a transformation through the following ports:
  • Input ports.
    Receive data.
  • Output ports.
    Pass data.
  • Input/output ports.
    Receive data and pass it unchanged.
Every source instance, target instance, mapplet, and transformation contains a collection of ports. Each port represents a column of data:
  • Sources provide data, so they contain only output ports.
  • Targets receive data, so they contain only input ports.
  • Mapplets contain only input ports and output ports.
  • Transformations contain a mix of input, output, and input/output ports, depending on the transformation and its application.
To connect ports, you drag between ports in different mapping objects. The Designer validates the connection and creates the connection only when the connection meets link validation and concatenation requirements.
You can leave ports unconnected. The Integration Service ignores unconnected ports.

Updated July 02, 2020