schema file

[kavuri]

Hi,
I am getting different formatted files like comma seperated, continuos length, pipe delimited etc. All are having data not in the same order. I want to read this data and do the necessary modifications and need to write into a common database table or file.

Below are some examples of data.

I dont know how to use a schema file. Can anybody tell me how I can use schema file to read this data into fields. On total I am having 4 or 5 fields in this case.

As I am having so many files to read, I dont want to maintain different jobs.

Please let me know some solution.

Thanks
Kavuri

[ray.wurlod]

A schema file is a standard Orchestrate record schema that accurately describes the format of your data, but the record schema is stored in a separate file rather than as properties of your Sequential File stage.

You can create them simply by saving existing table definitions as record schema files.