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.
Creating and reading the hash file in the same job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 48
- Joined: Fri Feb 29, 2008 1:09 am
- Location: Bangalore
Creating and reading the hash file in the same job
Thanks&Regards
S.Swathi
S.Swathi
Re: Creating and reading the hash file in the same job
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
still if you want, you can use a logic to create a dummy file in the same job and then use it.
DS User
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Creating and reading the hash file in the same job
Default behaviour when writing to a hashed file.SURA wrote:Very first run you need this file to be created. For the rest of the run you don't want.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers