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 |