Hi,
Can I append a lookup fileset in a parallel job...
I am having a sequential file as input and the data in it needs to be appended in a lookup fileset.Is it possible to append a lookupfileset.
Can any one suggest me a way to append data from a sequential file to a lookup or lookupfileset so that this lookup will act as future reference
Thanks!!
Append in a lookup fileset
Moderators: chulett, rschirm, roy
Append in a lookup fileset
Kruthika
Re: Append in a lookup fileset
Yes u can append a lookup file.
1. Create Hash file which reads from the input sequential file. This hash file is used as a reference.
2. Create a new job which checks for the new records against the above hash file. If the record is new, then it is inserted into the Hash file.
While designing the above job we need to take care of the following things:
1. Hash file name should be the same.
2. Cache should not be used.
1. Create Hash file which reads from the input sequential file. This hash file is used as a reference.
2. Create a new job which checks for the new records against the above hash file. If the record is new, then it is inserted into the Hash file.
While designing the above job we need to take care of the following things:
1. Hash file name should be the same.
2. Cache should not be used.
kruthika wrote:Hi,
Can I append a lookup fileset in a parallel job...
I am having a sequential file as input and the data in it needs to be appended in a lookup fileset.Is it possible to append a lookupfileset.
Can any one suggest me a way to append data from a sequential file to a lookup or lookupfileset so that this lookup will act as future reference
Thanks!!
Thanks
Pramod
Pramod