DSXchange

Posted: **Thu Aug 09, 2007 12:23 pm**

Hi,
I'm evaluating a job for optimization/performance etc, and I see that there's a JOIN being used. One of the reference file can be upto 6MB. Is it advisable to go for LOOKUP in place of this JOIN ?
Thanks

Posted: **Thu Aug 09, 2007 1:21 pm**

vijayrc wrote:Hi,
I'm evaluating a job for optimization/performance etc, and I see that there's a JOIN being used. One of the reference file can be upto 6MB. Is it advisable to go for LOOKUP in place of this JOIN ?
Thanks

I think using Lookup stage ( with ref. link entire partitioning and input link unsorted) will enhance the performance.

DSXchange

6MB in Reference Data: OK for Lookup Or go for a JOIN

6MB in Reference Data: OK for Lookup Or go for a JOIN

Re: 6MB in Reference Data: OK for Lookup Or go for a JOIN