Creating Table DDL Dynamically from DataStage
Posted: Tue Sep 04, 2007 1:36 pm
I have a sequential file as a source that has over 150 columns. I have to read the file and dump the data to a teradata table.
(1) Either I first create the table using CREATE TABLE command outside
Datastage manually, then import the metadata and then use it
as a target.
OR
(2) Is there any other way, I can create the table Definition dynamically
using Datastage? I dont want to type CREATE TABLE (all column name
and type) manually.
It would be nice if I can read the source and dump it to a TEMP table,
them make the TEMP table a persistent table and just get the DDL.
Any thoughts?
(1) Either I first create the table using CREATE TABLE command outside
Datastage manually, then import the metadata and then use it
as a target.
OR
(2) Is there any other way, I can create the table Definition dynamically
using Datastage? I dont want to type CREATE TABLE (all column name
and type) manually.
It would be nice if I can read the source and dump it to a TEMP table,
them make the TEMP table a persistent table and just get the DDL.
Any thoughts?