LATIN1_0A Character set (Teradata) to UTF8 (Oracle)

[bhaskarjha]

Hello Experts,
Need your help. We have a requirement to process data which contains German character from Teradata to Oracle

Teradata (API/Enterprise) ---> Transformer -------> Oracle Enterprise
NLS (AMERICAN_AMERICA.WE8ISO8859P1) NLS (UTF8)
(ASCL_ISO8859-1)

While running the process Source system is able to read the data but unable to write it to Target Oracle DB.

Error message -
Oracle_Enterprise_7,0: The system(sqlldr <user>/<pass>@DSN CONTROL=ora.8582.542247.0.ctl LOG=ora.8582.542247.0.log BAD=ora.8582.542247.0.log.bad SILENT=header PARFILE=ora.8582.542247.0.par) failed; see the log file for the Oracle specific message.

Any suggestion.

Teradata Character set is 'LATIN1_0A' Oracle DB - Character set is UTF8.

Thanks a lot for your help.

[chulett]

see the log file for the Oracle specific message.

What's in the log?