how to specify Sparse Lookup
Moderators: chulett, rschirm, roy
how to specify Sparse Lookup
Iam new to datastage and i came to know about sparse lookup. I tried to see that option in the Look Up Stage but i coudnt find it. Can you please specify me in brief how to specify and where in the lookup stage.
-
vivekgadwal
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
Re: how to specify Sparse Lookup
This option is in the "Enterprise" stage of the database you are trying to use. I mean, if you are accessing Oracle or DB2, the sparse lookup option is present in their corresponding Enterprise stage. Please go through the documentation on how to do this.kravids wrote:Iam new to datastage and i came to know about sparse lookup. I tried to see that option in the Look Up Stage but i coudnt find it. Can you please specify me in brief how to specify and where in the lookup stage.
Vivek Gadwal
Experience is what you get when you didn't get what you wanted
Experience is what you get when you didn't get what you wanted
-
Shaanpriya
- Participant
- Posts: 22
- Joined: Thu Sep 11, 2008 11:47 pm
- Location: Bangalore
Re: how to specify Sparse Lookup
The lookup type can be specified in the Lookup type field in the source category of the database stageskravids wrote:Iam new to datastage and i came to know about sparse lookup. I tried to see that option in the Look Up Stage but i coudnt find it. Can you please specify me in brief how to specify and where in the lookup stage.