Page 1 of 1

reading from and writing to same hash file at a time?

Posted: Tue Jul 03, 2007 8:59 am
by mallikharjuna
I am doing the lookup by using one hash file and I have some conditions, if the conditions are satisfied then I want to write the record in the same hash file, which is one of the output link from the same transformer.
And one more thing is I am using link collector stage also in this job.

if it is possible then please send me reply as early as possible.

Thanks
Malli

Posted: Tue Jul 03, 2007 9:50 am
by ray.wurlod
We do not do "urgent" or "as early as possible" here. If you want "urgent" sign up with your support provider for premium service and learn the true cost of "urgent".

What you seek is definitely possible, and was answered in another thread as recently as today.

Essentially you need two Hashed File stages, pointing to the same hashed file. In the one being read from, set read cache to "Disabled, lock for update". In the one being written to, set write cache to Disabled.