informatica cloud to Vertica data load not handling special characters

kannan_1

Hello,

We are moving data from SFDC to Vertica using the Informatica cloud. But the special characters are not loading correctly in Vertica. 

Any help would be highly appreciated. 

Eg - 

For Source Colum , the valus is MONTRÉAL

where as for the destination it is - MONTR��AL

[Deleted User]

How do you connect with Vertica using odbc or plug in. This seems to be something with the locale of the destination. 

kannan_1

We are using the ODBC to connect.