Skip navigation
Contact Us
3049 Views 6 Replies Latest reply: Aug 6, 2013 2:41 AM by Sandeep Chettri RSS
Prashant Salve Novice 56 posts since
May 24, 2011
Currently Being Moderated

Dec 3, 2012 2:59 AM

lookup Connected and Unconnected

Hi All,

 

Could you please tell me which is faster lookup as performance purpose in detail.

 

Thanks

Prashant

  • will i Novice 45 posts since
    Jul 25, 2010
    Currently Being Moderated
    Dec 3, 2012 3:06 AM (in response to Prashant Salve)
    lookup Connected and Unconnected

    It depends on how much data your processing...i.e., the Lookup gonna cache.

    Its always the unconnected since, it returns one port value....both of them serves different purposes depends on the usage.

     

    Thanks

    Will

  • nithya shanmugam Novice 58 posts since
    Jan 11, 2012
    Currently Being Moderated
    Dec 3, 2012 4:11 AM (in response to Prashant Salve)
    lookup Connected and Unconnected

    Connected lookup:

     

    -->  Need to use for dynamic cache purpose

    ---> Use for returning multiple columns from single port

    ---> It will execute for each and every row, so it tooks long time

     

    Un-connected lookup:

     

    ---> static cache

    ---> It will return one port value

    ---> This will execute only if the lookup  condition satisfies.

     

    performance wise unconnected  lookup is better because its like reusable one and it will lookup the values only the condition meet the criteria.

     

     

     

     

    Regards,

    Nithya S.

  • Srinivasu Mamidi Newbie 3 posts since
    Dec 3, 2012
    Currently Being Moderated
    Dec 5, 2012 2:35 AM (in response to Prashant Salve)
    Re: lookup Connected and Unconnected

    Generally  Unconnected Lookup transformation will improve performance.But the scenario is demanded for using dynamic cache or multiple output ports,then we will go for Connected lkp.

     

    Unconnected can be called on conditionally and can be call multiple times in mapping.

    We can call lkp by  passing  deferent values  from deferent ports in expression .

     

    Thanks,

    Mamidi.

  • Arun Patro Newbie 7 posts since
    Oct 10, 2012
    Currently Being Moderated
    Dec 5, 2012 3:24 AM (in response to Prashant Salve)
    lookup Connected and Unconnected

    The choice of LKP depends upon the amount of data in the mapping stream.

     

    If the condition is such for every incoming record the lkp condition is utilized then better use a connected lkp rather than an unconnected vice-versa.

  • Ramakrishna B.V.S. Novice 55 posts since
    Jul 25, 2010
    Currently Being Moderated
    Dec 5, 2012 10:18 PM (in response to Prashant Salve)
    lookup Connected and Unconnected

    Connected lookup used for dynamic cache and return multiple columns from single port , But Un-connected lookup is for static cache and return one port value. Performance depends on how much data we are processing (cache). Better to use Unconnected Lookup transformation it will improve performance.

     

    Regards,

    B.V.S.Ramakrishna

  • Sandeep Chettri Novice 30 posts since
    Aug 2, 2013
    Currently Being Moderated
    Aug 6, 2013 2:41 AM (in response to Prashant Salve)
    Re: lookup Connected and Unconnected

    One good point about unconnected lkp is it can be re-used in multiple place.

More Like This

  • Retrieving data ...

Bookmarked By (0)