Page 1 of 1

Dynamically get metadata

Posted: Thu Jan 31, 2008 5:32 am
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.

Posted: Thu Jan 31, 2008 7:40 am
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.