Database Reference
In-Depth Information
When you execute the mapping, row-wise data will flow from the source to the
Expression transformation. The
:LKP
function passes the data to the Lookup
transformation, which compares the data based on the condition defined in the
Condition
tab, which in turn returns the data from the
Return
port to the Expres-
sion transformation, from where the data is passed further in the mapping.
5. Similarly, add another
LOCATION
output port to the Expression transformation.
Then, create another Lookup transformation. We cannot use the same Lookup
transformation, as the unconnected Lookup transformation can return only one
port. Follow the process described here to look up for the
AGE
port to complete
the mapping.
We have seen the implementation of connected and unconnected Lookup transformations.
