Issue Loading Records from Informatica to Teradata Using Odbc Connection
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.