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