DSXchange

Dear All, The log says that the 'Hash file size exceeds cache size'. i am using this hash file to check the 'Change Reord Capture' (CRC). due to this hash file size exceeds issue the update hash job is 'Aborted'. To avoid this, we need to increase the cache size for this hash file. Kindly suggest me...

Srini,

You can develop a routine for that and convert in to Oracle date format.

use 'OCONV' & ICONV functions in your routine and the date format choose 'D-YMD'.

correct me if i am wrong..