The features of connected lookup are as follows:
- It takes in the input directly from the pipeline.
- It actively participates in data flow, and both dynamic and static cache are used.
- It caches all lookup columns and returns default values as the output when the lookup condition does not match.
- It is possible to return more than one column value to the output port.
- It supports user-defined default values.