DSXchange

Hi,

I want to design a job in such a way that,have to create the hash file in the first transformer and in the next transformer i have to use it as lookup.
when i designed like this ,job is failing saying that not able to open the hash file.

so is there any settings need to follow ,so that hash file will get created before going to the next stage.

Create it how? Empty or populated? Typically one would do that in the same transformer to avoid this very issue, the hashed file would have both an input link and a reference link to it.

Very first run you need this file to be created. For the rest of the run you don't want. My advise is to create a dummy file before run this job as a one go is easy.

still if you want, you can use a logic to create a dummy file in the same job and then use it.

DS User

Or you could use a before-job subroutine (ExecTCL) to create the hashed file. It will, of course, be empty of both data and metadata if you do it this way, but it will still work.

SURA wrote:Very first run you need this file to be created. For the rest of the run you don't want.

Default behaviour when writing to a hashed file.