You can create multiple pipelines in a mapplet. Use multiple data sources or Input transformations. You can also use a combination of data sources and Input transformations.

Use one or more data sources to provide source data in the mapplet. When you use the mapplet in a mapping, it is the first object in the mapping pipeline and contains no input ports.

Use an Input transformation to receive input from the mapping. The Input transformation provides input ports so you can pass data through the mapplet. Each port in the Input transformation connected to another transformation in the mapplet becomes a mapplet input port.

When you use an Input transformation to provide the input for a mapplet, you can set default values in the output ports of the Input transformation. The default values in the Input transformation output ports become default values for the mapplet input ports. If NULL data is passed from the mapping to the Input transformation, the Data Integration Service replaces the NULL value with the default value. The mapplet input uses the default value.

You can connect an Input transformation to multiple transformations in a mapplet. You can also connect one port in an Input transformation to multiple transformations in the mapplet.

Input transformations can receive data from a single active source. Unconnected ports do not appear in the mapping editor.