Page 1 of 1
Complex Flat File Stage - Source File Extensions ?
Posted: Sat Jan 14, 2012 11:14 pm
by anu123
Hi
I will be receiving EBCDIC file in BINARY format and multiple record types (Header,Rec1,Rec2,Rec3,Rec4 and Trailer).
So i have question what are all file extensions (Example : .dat, txt ...) the Complex Flat File Stage will accept to read.
Please help me ...
Posted: Sat Jan 14, 2012 11:51 pm
by chulett
File extensions are pretty much meaningless in the UNIX world. Regardless of extension, it will read 'flat files'... text files, if you will.
Posted: Sun Jan 15, 2012 10:20 am
by anu123
Thanks for your reply
Is it possible to read .ebc or .bin files with CFF Stage ?
Posted: Sun Jan 15, 2012 10:50 am
by chulett
Are they text files?
Posted: Sun Jan 15, 2012 4:00 pm
by anu123
Yes, i am receiving files as sourcefile.bin and sourcefile.ebc
Posted: Sun Jan 15, 2012 7:44 pm
by ray.wurlod
The suffixes are indicative of the contents only. Nothing is enforced by them. Provided you have good metadata, you should be able to read them with Sequential File stage (if the structure is simple enough) or Complex Flat File stage.
EBCDIC is simply another way of encoding characters, as ASCII is.
I'd be a bit more careful with ".bin" suffix, which suggests "binary" data. But it should still be possible to read the data.