Automatic table creation based on the header in raw file during data loading data into Teradata using any load utility

Tools
Enthusiast

Automatic table creation based on the header in raw file during data loading data into Teradata using any load utility

Hi,

I have a set of CSV , XML, XLS data files available in a document library and the header (columns) will be different in each data file. I am trying to automatically load these data files into Teradata using TPT (or any other load utility) and as i am not aware of the header in the data files upfront, I want to understand if it is possible in TPT to automatically create the table in TD based on the header in the data files and then load the data. Any suggestions in this regard will be helpful.

1 REPLY
Teradata Employee

Re: Automatic table creation based on the header in raw file during data loading data into Teradata using any load utility

TPT does not automatically create tables.

The commands to create a table must be supplied by the user through the DDL operator.

-- SteveF