Importing Metadata from text 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
gagan8877
Premium Member
Premium Member
Posts: 77
Joined: Mon Jun 19, 2006 1:30 pm

Importing Metadata from text file

Post by gagan8877 »

I have a .txt file that contains column definitions (metadata) for approx 100 columns (the actual data file is separate). I want to import the metadata into DS. Whats the easiest way to import it? I had a look at the schema chapter in Parallel Job dev's guide but that seems a lot of work as the format in my txt file is different - without () brackets and semicolons, etc. Is there another way or another format that could be used?

Thanks
GS
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

I agree. I wrote my own in VB. If you export one table as XML. It is pretty easy to duplicate this format and import it.
Mamu Kim
Post Reply