DSXchange

Hi,

Can i write to same hashed file from more then one stage in a job.I want to recreate the file for each run.

I tried doing this and this worked.

But i wanted to know if it is safe doing this.

thanks
dhiraj

ALL writes to a hashed file are destructive overwrites, whether from one source or many. If the key being written already exists on the hashed file, then that row is replaced entirely with the columns of the new row.

If this is what you want to happen then, yes, it is "safe".

A hashed file behaves like a table, but only with record-level locking (table-level locking is available, but not through the Hashed File stage).

Indeed, if you desire some other behaviour, you may prefer to access the hashed file using a UV stage, where all of the characteristics of SQL (DML) are at your disposal.