I'm trying to import a TXT file (CSV converted to Tab Deliminated) to a table and keep running into issues with the date. I am fairly new to using Teradata or any Database tools, but can't seem to figure out this issue - either by reading, researching online, or talking with peers who have much more experience.
If there are any thoughts on how I can get this resolved, and import the data with the date, that would be awesome.
I have put my table and sample data below, the "*" are where I have removed the actual titles.
seems your default date format in target talble and the data formt in source file are different.
while importing you may have to use below format converstion in insert statment -
cast(:survey_date as date format 'yyyymmdd')
and i hope you don't have header in your datafile.
You have not shared you script settings.
Are you using setting like :
.import vartext file=/home/adc.dat;using id(varchar(20)) .....
Also, you can think of using CSVLD function too.
Probably that might be the case.Date formats are different in source and target.Check with the delimiter too in the options tab.