- Connected lookup receives input values directly from mapping pipeline whereas UnConnected lookup receives values from :LKP expression in another transformation.
- Connected lookup trasformation will process each and every row whereas UnConnected lookup will not process each and evry row. It will return the values based expression condition.
- If the LKP condition is not matched the lookup transformation will return the default value in case of Connected lookup. If no match found for the LKP condition, the lookup transformation will return null values in case of Unconnected lookup.
- Connected lookup transformation can use static or dynamic cache, whereas Unconnected lookup can use only static cache.
- Connected lookup returns multiple columns from the same row whereas the UnConnected lookup has one return port and returns one column from each row.
- Connected lookup supports user-defined default values and the UnConnected lookup does not support user defined values.
Difference between Connected and UnConnected Lookup Transformation:
Subscribe to:
Post Comments
(
Atom
)
I’m very glad to found this website because; it carries awesome and actually good data in favor of readers.
ReplyDeleteclover
www.n8fan.net
Pretty good post. I found your website perfect for my needs. Thanks for sharing the great ideas.
ReplyDeletewww.imarksweb.org
Very simple points to understand the difference between the connected & unconnected lookups. Thanks
ReplyDeleteI really had a great time stopping by your site, it gives me a lot of information. You can also visit my site, thank you!
ReplyDeletetriciajoy.com
www.triciajoy.com
Thanks for this information; I hope it will use much reader who looking you regularly likes me…
ReplyDeleteRegards,
Informatica training in chennai
Nice article keep it up
ReplyDeleteinformatica training , infromatica online training, informatica training in bangalore, infromatica online training in bangalore