Hi
What is the difference between Sparse Lookup and Normal Lookup?
Sparse Lookup and Normal Lookup
Moderators: chulett, rschirm, roy
Parallel Job Developer's Guide is a good place too. If you still have trouble understanding anything we are here to help you. :D
Last edited by kris007 on Mon Aug 02, 2010 6:22 pm, edited 1 time in total.
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
Re: 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.harryhome wrote:Hi
What is the difference between Sparse Lookup and Normal Lookup?