Page 1 of 1
reading thro seq file stage
Posted: Thu Mar 15, 2012 10:01 am
by India2000
Hi,
is it possible to read multiple fixed witdth flat files thro a single seq stage?How??
Posted: Thu Mar 15, 2012 10:29 am
by chulett
As long as they share the same structure / metadata, use the File Pattern option.
Posted: Thu Mar 15, 2012 10:52 am
by India2000
no they aren't ..I'm seperating out header nd details..reading them ..
Posted: Thu Mar 15, 2012 11:23 am
by chulett
Not what I said... do they all share the same structure? Same format for headers, detail, etc with the only difference being the name of the file?
Posted: Thu Mar 15, 2012 11:26 am
by India2000
NO..
No they are of different dml structure
Posted: Thu Mar 15, 2012 11:37 am
by chulett
Then it's up to you if you want to go to all the trouble of reading them all as one long string and then parsing each one "in job" once you determine what structure it is.
Posted: Thu Mar 15, 2012 7:45 pm
by djbarham
India2000 wrote:no they aren't ..I'm seperating out header nd details..reading them ..
As long as each record has a record type field, you can handle different record types and multiple files using the file pattern option in the Complex Flat File stage.
Posted: Sun Mar 18, 2012 8:53 pm
by India2000
I want to extract date value from the header for one of the columns in the output file from the fixed width flat file.I can't use the file with header with details for extracting.I want to know is there a way I can extract this header in a different file and then process.