Lookup transformation has four different types of ports. To view the ports of Lookup transformation, click on the Ports tab of Lookup transformation, as shown in the following screenshot:
The ports are as follows:
- Input Ports (I):These receive the data from other transformations. This port will be used in the Lookup condition. You need to have at least one input port.
- Output Port (O): These pass the data out of the Lookup transformation to other transformations.
- Lookup Port (L): Each column is assigned a Lookup and Output port when you create the Lookup transformation. If you delete the lookup port from the flat file lookup source, ...