Page 1 of 1

How to read a complex flat file??

Posted: Thu Jan 22, 2004 9:57 am
by ramesh
How do I read a complex flat file that contains occurances and redefines and there are no redefines depending on.

Ramesh

How to read a complex flat file??

Posted: Thu Jan 22, 2004 10:25 am
by bigpoppa
It's not easy to read that type of data in PX (or in Server). Make the data as flat as you can and preferrably fixed width prior to importing into PX. Then, tag each incoming row with an indicaor that specifies the format of each row, and use corresponding schemas to parse the row.

- BP

Posted: Thu Jan 22, 2004 11:18 am
by ramesh
In actuality we are able to achieve reading complex flat files with the server via the CFF Stage very easily.

Can someone help me out how to read the complex flat file in PX.

Ramesh