Difference between Connected and UnConnected Lookup Transformation:

  1. Connected lookup receives input values directly from mapping pipeline whereas UnConnected lookup receives values from :LKP expression in another transformation.
  2. 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.
  3. 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.
  4. Connected lookup transformation can use static or dynamic cache, whereas Unconnected lookup can use only static cache.
  5. Connected lookup returns multiple columns from the same row whereas the UnConnected lookup has one return port and returns one column from each row.
  6. Connected lookup supports user-defined default values and the UnConnected lookup does not support user defined values.

6 comments :

  1. I’m very glad to found this website because; it carries awesome and actually good data in favor of readers.

    clover
    www.n8fan.net

    ReplyDelete
  2. Pretty good post. I found your website perfect for my needs. Thanks for sharing the great ideas.

    www.imarksweb.org

    ReplyDelete
  3. Very simple points to understand the difference between the connected & unconnected lookups. Thanks

    ReplyDelete
  4. I really had a great time stopping by your site, it gives me a lot of information. You can also visit my site, thank you!

    triciajoy.com

    www.triciajoy.com

    ReplyDelete
  5. Thanks for this information; I hope it will use much reader who looking you regularly likes me…
    Regards,
    Informatica training in chennai

    ReplyDelete

> Related Posts with Thumbnails
 

Copyright © 2012. GS dot net - All Rights Reserved - Design by BTDesigner - Proudly powered by Blogger