DSXchange

Hi,

Does changing the partition for a Sparse lookup have any effect, since it is directly firing the queries to the DB?. I have all the stages with Auto partition, but just wanted to know whether changing the partition for a sparse lookup will have any impact.

No, this should have no effect on the lookup behaviour whatsoever, though I would have some suspicion that using Entire might result in multiple matching, if your lookup runs in parallel. Definitely best you stick with Auto - is there some reason why you are thinking of changing this?

Hi, Thanks. I am not sure whether Auto-partition is best to use. So i thought i would use hash partition. But just wanted to clarify whether it is necessary to change for sparse lookup.