Informatica vertica target connector

Hi ,

I cannot see the option USE SINGLE TARGET in the target writer properties .

The session is getting failed due to the error

Severity    Timestamp    Node    Thread    Message Code    Message
ERROR    3/7/2014 5:47:20 PM    node01_nmetldev1    WRITER_1_*_1    VERTICA_1037    [ERROR] SQL error: [Vertica][VJDBC](100176) Failed to connect to host 10.xx.xx.xxx on port 5433. Reason: Connection timed out

The IP address shown is not at all the IP address given in the connection string .

Please look into it



  • Options
    Prasanta_PalPrasanta_Pal - Select Field - Employee
    It is not necessary to give IP address of all the nodes, JDBC driver needs IP of one node.
    You may test if the JDBC connection is successful by other tool.
  • Options

    I'm getting same error when I try to load record which has date column in it from Informatica version 9.6.


    Is there any limitation in loading the date columns?

Leave a Comment

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