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?
Sparse LookUp Requirement
Moderators: chulett, rschirm, roy
Re: Sparse LookUp Requirement
This may help you...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?
viewtopic.php?t=128686