How to load date into teradata from file with TPT

Database

How to load date into teradata from file with TPT

Hi ,

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.

Thanks
Tags (1)
1 REPLY

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)