seq file

agpt · Post by **agpt** » Mon Sep 27, 2010 11:56 am

Hi All,

Has anyone ever used a sequential file for look up as reference table?

anbu · Post by **anbu** » Mon Sep 27, 2010 12:08 pm

Sequential file can be used in lookup as reference.

What do you want to know?

agpt · Post by **agpt** » Mon Sep 27, 2010 12:11 pm

anbu wrote:Sequential file can be used in lookup as reference.

What do you want to know?

Thanks Anbu. What exactly is a difference between file set and a sequential file. I have 5 sequential files which I need to use as reference for one input only. One option is I can append them to each other and make one large file and use it in reference. Is it possible to keep these 5 files as individual files only and create a file set which would read all of them one by one ?

ray.wurlod · Post by **ray.wurlod** » Mon Sep 27, 2010 5:14 pm

Another possibility, if all have the same record structure, is to read them all using a Sequential File stage with the "read as File Set" property enabled.