rcoon7

 Profile Answers by rcoon7 

• Mar 10th, 2008

 

it all depends on the enviornment are running and the memory allocated and the number of concurrent processes running.

It is though not advisible to do the same as this would be definetly a performance hit under normal condition.

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Apr 15th, 2008

 

I think it is not adviseable to use a 1GB lookup file , it will definitely effect the parallel processing of other applications and affect the performance.

I would prefer to use the MFS lookup file and not serial lookup file in this case.

anujaja

 Profile Answers by anujaja 

• Aug 25th, 2009

 

I will suggest you to use Join instead of Lookup for such voluminous data

abhi_fresh_as_dew

 Profile Answers by abhi_fresh_as_dew 

• Feb 3rd, 2010

 

Processing 1GB data with a small lookup file is good ... but to make the 1GB data as a lookup file is mistake.Use mfs lookups instead if its at most needed.