Page 1 of 1
Lookup stage
Posted: Mon Apr 18, 2011 4:26 am
by mallikachaithu
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
Posted: Mon Apr 18, 2011 5:08 am
by zulfi123786
Please see the Parallel Job Developer Guide, Look for the chapter "Look Up Stage".
Posted: Mon May 09, 2011 12:20 am
by huahero
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.
Posted: Mon May 09, 2011 1:14 am
by abinaydutt
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.