I have Job J2SmsXfm which uses Hashfile as reference lookup "ORIG_SDCA.LookUpSDCA_A"
"preload file to memory" is disabled for the above hashfile.
when iam running above job, log shows
"J2SmsXfm..ORIG_SDCA.LookUpSDCA_A: Read caching enabled, cache size (999MB)"
If I change "preload file to memory" to Enabled and run, log shows
"J2SmsXfm..ORIG_SDCA.LookUpSDCA_A: Read caching disabled, file size exceeds cache size"
I couldnt understand why it is behaving in reversed manner.
Can anyone explain me what is happening.
Strange problem in Hashfile caching
Moderators: chulett, rschirm, roy
Strange problem in Hashfile caching
Lakshmi Narayana A.
Decision Support Systems
RELIANCE INFOCOMM.
B Block, Ground Floor ,DB11
Dhirubhai Ambani Knowledge City
Koparkhairane,Navi Mumbai-400709.
INDIA
Phone Number:30380241
Decision Support Systems
RELIANCE INFOCOMM.
B Block, Ground Floor ,DB11
Dhirubhai Ambani Knowledge City
Koparkhairane,Navi Mumbai-400709.
INDIA
Phone Number:30380241
Re: Strange problem in Hashfile caching
It is because u are the person who has written the job !!!!!!!!
Sanjay
Sanjay
LNarayana wrote:I have Job J2SmsXfm which uses Hashfile as reference lookup "ORIG_SDCA.LookUpSDCA_A"
"preload file to memory" is disabled for the above hashfile.
when iam running above job, log shows
"J2SmsXfm..ORIG_SDCA.LookUpSDCA_A: Read caching enabled, cache size (999MB)"
If I change "preload file to memory" to Enabled and run, log shows
"J2SmsXfm..ORIG_SDCA.LookUpSDCA_A: Read caching disabled, file size exceeds cache size"
I couldnt understand why it is behaving in reversed manner.
Can anyone explain me what is happening.