Sparse LookUp Requirement
Posted: Mon Oct 19, 2009 9:08 am
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?
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?