Sparse Lookup and Normal Lookup

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
harryhome
Participant
Posts: 112
Joined: Wed Oct 18, 2006 7:10 am

Sparse Lookup and Normal Lookup

Post by harryhome »

Hi

What is the difference between Sparse Lookup and Normal Lookup?
Top
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

Search the forum
You are the creator of your destiny - Swami Vivekananda
Top
kris007
Charter Member
Charter Member
Posts: 1102
Joined: Tue Jan 24, 2006 5:38 pm
Location: Riverside, RI

Post by kris007 »

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
Top
synsog
Premium Member
Premium Member
Posts: 232
Joined: Sun Aug 01, 2010 11:01 pm
Location: Pune

Re: Sparse Lookup and Normal Lookup

Post by synsog »

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.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”