schema file
Posted: Wed Apr 09, 2008 7:28 pm
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
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