I have the date column in the file in the format 'mm/dd/yyyy'. I am trying to load this date column in the teradata with the TPT. But it is failing. The same issue we had in the fastload also. But there if i give the DATE, FORMAT 'mm/dd/yyyy' this things works.
But in the TPT it is not accepting this and hence failing. Kindly let me know how to handle the date in the TPT.
Re: How to load date into teradata from file with TPT
when i m using this in my insert query it is failing
CAST(:REPORTING_DATE AS DATE FORMAT ''MM/DD/YYYY''),
PRODUCER_OPERATOR: Total files processed: 0. CONSUMER_OPERATOR: aborting due to the following error: CONSUMER_OPERATOR: Expression not allowed in Fast Load Insert, column REPORTING_DATE. Job step MAIN_STEP terminated (status 12) Job edwt terminated (status 12)