DSXchange

Posted: **Mon Aug 02, 2010 12:45 pm**

Hi

What is the difference between Sparse Lookup and Normal Lookup?

Posted: **Mon Aug 02, 2010 12:58 pm**

Search the forum

Posted: **Mon Aug 02, 2010 1:33 pm**

Parallel Job Developer's Guide is a good place too. If you still have trouble understanding anything we are here to help you. :D

Posted: **Mon Aug 02, 2010 5:13 pm**

harryhome wrote:Hi

What is the difference between Sparse Lookup and Normal Lookup?

When you have large amount of data comming from source its better to use normal lookup and if you are having incremental comming better go for sparse so that the performance will be good and when you use sparse look up use ORCHESTRATE.Key_field_name= Key_field_name. in where condition.

DSXchange

Sparse Lookup and Normal Lookup

Sparse Lookup and Normal Lookup

Re: Sparse Lookup and Normal Lookup