Hash File lookup query
Posted: Wed Aug 02, 2006 9:08 am
Hi Dsxians,
I am using three hash files in a job,each having millions of records,i would like to know if i enable preload file into memory option for all the three hash lookups will it cause overflow of memory there by causing job to abort or performance issue.Please let me know ur views.
Thanks
satheesh
I am using three hash files in a job,each having millions of records,i would like to know if i enable preload file into memory option for all the three hash lookups will it cause overflow of memory there by causing job to abort or performance issue.Please let me know ur views.
Thanks
satheesh