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
Lookup stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
-
- Participant
- Posts: 4
- Joined: Fri Apr 15, 2011 1:50 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.
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.