What are the different types of lookup? When one should use sparse lookup in a job?

at

2 comments:

  1. Balanarasimha Rao UdaJune 22, 2011 at 2:01 PM

    There are two types of lookups
    1. Normal lkp
    2. Sparse lkp

    Normal lkp: To perform this lkp data will be stored in the memory first and then lkp will be performed bue to which it takes more execution time

    Sparse lkp: Sql query will be directly fired on the database related record due to which execution is faster than normal lkp

    if u use normal lookup it takes the entire
    table into memory and perform lookup..coming to sparse lookup it directly perform the lookup in database level.

    ReplyDelete
  2. REDDYAugust 11, 2011 at 6:36 PM

    two types of lookups in lookup stage..
    1.normal lookup
    2.sparse lookup

    huge amount of data at reference link then sparse lookup is used

    ReplyDelete

Subscribe to: Post Comments (Atom)