I need to load some curreny symbol from my source(Oracle) to target table(Teradata). I have used informatica in between to perform some logic on other columns. Initially Informatica was not not able to read those symbol from the source itself. We changed the codepage of integration service to UNICODE and now Informatica is able to read it but it is failing to load some currency symbol with the teradata driver error like" Character is not translationable". As per my understanding if I change the character set of Teradata server, issue will get resolved. Currently the Character set is ASCII.
Can anyone suggest on the same. Thanks in advance.