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.