Hi,
Informatica does not allow vertica connections to do lookups against tables in the Vertica database. Whats the work-around? ODBC?
Thanks.
Vertica lookup in Informatica
Moderator: NorbertKrupa
-
- Intermediate
- Posts: 149
- Joined: Mon Apr 30, 2012 10:04 pm
- Location: New York
- Contact:
Re: Vertica lookup in Informatica
Which connection to Vertica are you using from informatica?
Re: Vertica lookup in Informatica
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
The vertica drivers I have is version 5.1.4