Informatica session fails with RR_4035 : SQL Error [ ORA-29275: partial multibyte character
The source database or the target database has multibyte characters.
To resolve this you have to change the Code Page of the Relational Connection
1)Open Workflow Manager
2) Click on the Relational Connections and choose the relational connection
3) Change the Code Page to : UTF-8 encoding of Unicode.
If the error occurs in any other tool, then make sure the connection you make to the database is with the correct code page which supports Unicode.