Issue Loading Records from Informatica to Teradata Using Odbc Connection

Connectivity
N/A

Issue Loading Records from Informatica to Teradata Using Odbc Connection

Hi Everyone,

It is a strange issue, I am loading few records from SAP source to Target TD table through Informatica after ABAP generation. Now the issue is that every time I load with any range of Data reading from param file, its always the first 2 records gets rejected.

Issue on session log is - [Teradata][ODBC Teradata Driver] Invalid date/time/timestamp value

I have changed the code page settings from UTF8 to ASCII, now only the first record is getting rejected.

Do I need to do further modification in Code page of connection? or there is some other issue at TD side?

Stuck up with this issue for 2 days. Please help as soon as possible.

Thanks,

Guha.