We are using TDLOAD mechanism to load Staging Layer from File. I belive the default DATE and Timestamp format in the input file which has been configured in DBS Utility would be accepted only. e.g. YYYY-MM-DD.
Is there any functionality/option in the TDLOAD mechanism to accept custom DATE and TIMESTAMP format specified in the Run Time?
tdload does not support that functionality (yet) from a global standpoint.
Until we add that feature, you will have to write a TPT script and use the FORMATIN/FORMATOUT syntax in the schema to have TPT convert your Date/Timestamp data from its original format to the format expected by Teradata.