Append in a lookup fileset

[kruthika]

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!!

[pramod_au]

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.

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!!

[kruthika]

Thanks for ur response!!

But there is no hash file stage in px parallel job...
then how can i create a hash file??