Connected Lookup :
1) Connected Lookup can return more than one value.The number of Output port can be more than one.
2) The Cache will store all the lookup columns.
3) Can use both Static and dynamic cache.
4) As name suggests , these lookups are connected with the flow and they get their input from pipeline.
Unconnected Lookup :
1) They can return only one value.
2) The cache will store the return port and output port.
3) Can use only static cache.
4) These lookups are not connected and get their input values through expression (:LKP)
1) Connected Lookup can return more than one value.The number of Output port can be more than one.
2) The Cache will store all the lookup columns.
3) Can use both Static and dynamic cache.
4) As name suggests , these lookups are connected with the flow and they get their input from pipeline.
Unconnected Lookup :
1) They can return only one value.
2) The cache will store the return port and output port.
3) Can use only static cache.
4) These lookups are not connected and get their input values through expression (:LKP)
This comment has been removed by a blog administrator.
ReplyDelete