Lookup stage

mallikachaithu · Post by **mallikachaithu** » Mon Apr 18, 2011 4:26 am

Hi,

Can anyone pls explain me the difference between normal look up and sparse lookup.
If i want to use sparse lookup, how do i set the options in the stage for sparse lookup.

Thanks in advance to one and all for the gr8 help.
Mallika

zulfi123786 · Post by **zulfi123786** » Mon Apr 18, 2011 5:08 am

Please see the Parallel Job Developer Guide, Look for the chapter "Look Up Stage".

huahero · Post by **huahero** » Mon May 09, 2011 12:20 am

As my understanding:

Normal lookup can have multiple ref-links and read reference data into memory.
Sparse lookup have only 1 ref-link, read reference data from database directly.

abinaydutt · Post by **abinaydutt** » Mon May 09, 2011 1:14 am

Hi,

In Sparse lookup we cant map the key columns in the output tab.
we need to mention the where condition using keys as <local_odbc_key>=orchestrate.<lookup_stage_key>.this would be matched automatically if the read method is an autogenerated sql or table(only if the keys are matching else we need to mention explicitly through user defined sql).and the condition need to be mentioned in the lookup stage(eg:continue,drop,reject etc,.) depending on the requirement.