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
6MB in Reference Data: OK for Lookup Or go for a JOIN
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 17
- Joined: Fri May 25, 2007 11:59 am
Re: 6MB in Reference Data: OK for Lookup Or go for a JOIN
I think using Lookup stage ( with ref. link entire partitioning and input link unsorted) will enhance the performance.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