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.
TPT does not automatically create tables.
The commands to create a table must be supplied by the user through the DDL operator.