A Joiner transformation has different port types that determine how the Data Integration Service performs the join.
A Joiner transformation has the following port types:
Master
Ports that link to the master source in the mapping.
Detail
Ports that link to the detail source in the mapping.
Dynamic Port
Receives or returns ports in a dynamic mapping. A dynamic port can receive one or more columns from an upstream transformation and create a generated port for each column. A dynamic output port can return one or more generated ports. You can define input rules to determine which columns a dynamic port receives.
You can change a port from a master port to a detail port. You can also change a port from a detail port to a master port. When you change the port type of one port, you change the port type of all ports. Therefore, when you change a master port to a detail port, you change all master ports to detail ports and all detail ports to master ports.