ODBC does case-insensitive string compare in Informatica

Moderator: NorbertKrupa

Post Reply
beth
Intermediate
Intermediate
Posts: 58
Joined: Tue Oct 01, 2013 12:42 pm

ODBC does case-insensitive string compare in Informatica

Post by beth » Tue Feb 10, 2015 5:18 pm

Hi all,

Anyone have any experience using Vertica and Informatica with ODBC? The problem we are having is that when strings are compared form the lookup it is ignoring case in 6.1.x but not with 4.1 drive. I've already tried changing the Locale settings and disabling cache look up in Informatica.

Any help on this issue would be much appreciated!

Post Reply

Return to “ODBC”