Complex Flat File Stage - Source File Extensions ?

anu123 · Post by **anu123** » Sat Jan 14, 2012 11:14 pm

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

chulett · Post by **chulett** » Sat Jan 14, 2012 11:51 pm

File extensions are pretty much meaningless in the UNIX world. Regardless of extension, it will read 'flat files'... text files, if you will.

anu123 · Post by **anu123** » Sun Jan 15, 2012 10:20 am

Thanks for your reply

Is it possible to read .ebc or .bin files with CFF Stage ?

chulett · Post by **chulett** » Sun Jan 15, 2012 10:50 am

Are they text files?

anu123 · Post by **anu123** » Sun Jan 15, 2012 4:00 pm

Yes, i am receiving files as sourcefile.bin and sourcefile.ebc

ray.wurlod · Post by **ray.wurlod** » Sun Jan 15, 2012 7:44 pm

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.