The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Lookups using the Vertica Informatica plugin 7.0


Why can't I use the Vertica Informatica plugin as the source for a lookup? Is there any workaround apart from ODBC as we are dealing with large tables and ODBC inherently will be very slow.


  • Hi Nish,

    By installing and configuring the HP Vertica Informatica Plug-in, you can use HP Vertica with Informatica PowerCenter both as a source and as a target database

    Are you receiving an error when trying to perform the lookup? If so, what is the error? What version of Vertica and Informatica are you using? When did you download the Informatica Plugin from the Vertica website?

    - Mitch
  • Thanks for the reply Mitch.

    My question is about using the plugin for the Informatica lookup transformation - is that possible or still a future feature?

    FYI, we are able to use the plugin successfully for source and targets.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.