- 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.
Tuesday, May 8, 2012
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
Very simple points to understand the difference between the connected & unconnected lookups. Thanks
ReplyDeleteNice article keep it up
ReplyDeleteinformatica training , infromatica online training, informatica training in bangalore, infromatica online training in bangalore
ReplyDeleteGreat Article
Artificial Intelligence Projects
machine learning final year projects 2020
JavaScript Training in Chennai
JavaScript Training in Chennai Project Centers in Chennai
I have read your blog its very attractive and impressive. I like it your blog. Digital Marketing Company in Chennai