Need to load data from a flat file to teradata table

Teradata Applications

Need to load data from a flat file to teradata table

Hi,

I need to prepare .sh script to load data from a flat file to teradata tables. Below are the flexibilities to be handled:

1. The file name should popaulate as the value for the first column.

2. The columns in flat file can come in any order

3.The non-mandatory fields in a record can be missing.

Can any one help on this requirement. Also let me know for any further clarfications.

Thanks, Prasanth.