Dynamically get metadata

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
sarat.srinivas@tcs.com
Participant
Posts: 26
Joined: Fri Jul 13, 2007 6:33 am

Dynamically get metadata

Post by sarat.srinivas@tcs.com »

Hi all ,
I have a Complex requirement in Datastage. I am using Information Server 8.0.1. I have a huge fixed field length file with records of different MetaData.That is each records with different fields ( with no field separator and are of fixed length ) need to be loaded into separate tables.
Record1 ----- table1
record2 ------ table2
record3 -----table3 and so on ...

Example :

abcdefghijklmnopqrstuvwxyz
12345678901214617181919010010101010
jcdsvdflvsdfklvsdfvkdfsjvlsdfjvldsjdsvjsdjvvdjkvndvsdvsdv
sdnvsdnvsdfj
nvdvdvsdmvsdmvsdnmvvnsdvnd

Can we load the file ( as in the above example ) into separate tables without using any scripting .
abcdefghijklmnopqrstuvwxyz ----------- table1
12345678901214617181919010010101010---------table2
jcdsvdflvsdfklvsdfvkdfsjvlsdfjvldsjdsvjsdjvvdjkvndvsdvsdv---table3
sdnvsdnvsdfj-----table4
nvdvdvsdmvsdmvsdnmvvnsdvnd------table5.
Can we use Schema files for getting metadata dynamically ?I am just a novice in Datastage .So , I request you to provide details eloborately.
V.Sarat Srinivas
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Are they truly fixed width? Certainly the examples you posted are not.

You probably can use schema files, but only downstream of reading the single field first. Perhaps you can parse in a Transformer stage, perhaps you can parse in a Column Import stage.

Perhaps you can get more coherent requirements.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply