Page 1 of 1
seq file
Posted: Mon Sep 27, 2010 11:56 am
by agpt
Hi All,
Has anyone ever used a sequential file for look up as reference table?
Posted: Mon Sep 27, 2010 12:08 pm
by anbu
Sequential file can be used in lookup as reference.
What do you want to know?
Posted: Mon Sep 27, 2010 12:11 pm
by agpt
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 ?
Posted: Mon Sep 27, 2010 5:14 pm
by ray.wurlod
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.