Vertica lookup in Informatica

Moderator: NorbertKrupa

Post Reply
sean
Newbie
Newbie
Posts: 11
Joined: Mon Sep 10, 2012 6:52 pm

Vertica lookup in Informatica

Post by sean » Thu Sep 27, 2012 5:03 pm

Hi,

Informatica does not allow vertica connections to do lookups against tables in the Vertica database. Whats the work-around? ODBC?

Thanks.

jpcavanaugh
Intermediate
Intermediate
Posts: 149
Joined: Mon Apr 30, 2012 10:04 pm
Location: New York
Contact:

Re: Vertica lookup in Informatica

Post by jpcavanaugh » Thu Sep 27, 2012 5:07 pm

Which connection to Vertica are you using from informatica?

sean
Newbie
Newbie
Posts: 11
Joined: Mon Sep 10, 2012 6:52 pm

Re: Vertica lookup in Informatica

Post by sean » Thu Sep 27, 2012 5:25 pm

To load data, I'm created a connection of type "VerticaConnection" in the workflow manager and that worked when inserting data into Vertica. However, I added a lookup to the mapping, but that connection does not show up in the list for the lookup

The vertica drivers I have is version 5.1.4

Post Reply

Return to “Informatica PowerCenter”