| Connected Lookup | Unconnected Lookup |
|---|---|
| Connected lookup participates in mapping | It is used when lookup function is used instead of an expression transformation while mapping |
| Multiple values can be returned | Only returns one output port |
| It can be connected to another transformations and returns a value | Another transformation cannot be connected |
| Static or dynamic cache can be used for connected Lookup | Unconnected as only static cache |
| Connected lookup supports user defined default values | Unconnected look up does not support user defined default values |
| In Connected Lookup multiple column can be return from the same row or insert into dynamic lookup cache | Unconnected lookup designate one return port and returns one column from each row |