How to read a complex flat file??

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ramesh
Participant
Posts: 2
Joined: Wed Jan 21, 2004 10:32 am

How to read a complex flat file??

Post by ramesh »

How do I read a complex flat file that contains occurances and redefines and there are no redefines depending on.

Ramesh
bigpoppa
Participant
Posts: 190
Joined: Fri Feb 28, 2003 11:39 am

How to read a complex flat file??

Post 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
ramesh
Participant
Posts: 2
Joined: Wed Jan 21, 2004 10:32 am

Post 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
Post Reply