What are the features of connected lookup?

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.