Sparse LookUp Requirement

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kool_cons
Participant
Posts: 68
Joined: Thu Jul 07, 2005 3:41 pm

Sparse LookUp Requirement

Post by kool_cons »

Hello,
I want to know where do we use Sparse Lookup exactly. We are using Joins right now and want to replace with Sparse if the rows from Input are less compared to Lookup dataset. I dont know the exact ratio between Input/Reference. Is the sparse lookup good with 1 rows(input):20 rows(referenceLookup) or some other proven ratio?
Top
dsedi
Participant
Posts: 220
Joined: Wed Jun 02, 2004 12:38 am

Re: Sparse LookUp Requirement

Post by dsedi »

kool_cons wrote:Hello,
I want to know where do we use Sparse Lookup exactly. We are using Joins right now and want to replace with Sparse if the rows from Input are less compared to Lookup dataset. I dont know the exact ratio between Input/Reference. Is the sparse lookup good with 1 rows(input):20 rows(referenceLookup) or some other proven ratio?
This may help you...
viewtopic.php?t=128686
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”