I'm trying to load data from Oracle to Teradata using OleLoad TPT Insert operator.
If the session character set is set to UTF8 then some rows are being sent to Error table 1.
If the session character set is set to ASCII then I'm getting the below error
Error while using ASCII character set might be because the data contains multibyte character which can't be converted to single byte. So, only option we have in 13.10 version of OleLoad is to run the job in UTF8 session charset.
Now, coming to Error table issue. As far as I know, SQL Insert operator does not have any Error table.
The job mentioned here (data copying from Oracle to Teradata), will have Dataconnector Operator as producer and SQL insert operator as Consumer. Not sure from where this Error table is being created and error records are going into that table. OLE DB Access Module does not create such table for sure. It only gets the data from the provider and give it to Utilities.
Please provide more details.
-> Complete job output.
-> Whether data contains multibyte characters Data type of columns being copied from Oracle.
-> Version information of OleLoad and TPT.