Is there a way to only load specific columns from a flat file using tdload? Say my flat file has five columns, but I only need the last three. Is there anyway to specify the first two columns as dummy columns or something equivalent maybe in the schema? Thanks for your help!
This is not currently available with "tdload".
In order to do this, you would need a script so that the "SELECT" portion of the APPL-SELECT canbe used to filter out the unwanted columns.
The schema must contain all 5 columns because the schema defines what the data will look like as it arrives to TPT (so the file reader knows how to process the incoming records).