Page 1 of 1
Vertica lookup in Informatica
Posted: Thu Sep 27, 2012 5:03 pm
by sean
Hi,
Informatica does not allow vertica connections to do lookups against tables in the Vertica database. Whats the work-around? ODBC?
Thanks.
Re: Vertica lookup in Informatica
Posted: Thu Sep 27, 2012 5:07 pm
by jpcavanaugh
Which connection to Vertica are you using from informatica?
Re: Vertica lookup in Informatica
Posted: Thu Sep 27, 2012 5:25 pm
by sean
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