The bulk file uploader can create the table DDL if the table does not exist in Data Vault. The uploader also has a limited ability to alter tables.
When you schedule a job to load data into a table, the bulk file uploader creates the DDL, if the table does not exist in Data Vault. If the table exists, the job compares the table attributes in the master XML file with table attributes in the Data Vault metadata.
If you need to add new columns to an existing table, add the column details at the end of the column list in the XML file. The uploader alters the table to add the column.
If the data type in the master XML file is different from the Data Vault metadata and there is no possibility of loss of precision, the uploader alters the existing table attributes to the values in the master XML file. For example, the type CHAR(100) can be altered to CHAR(200), but not the reverse. You cannot alter the column to a different type.