Informatica no rows inserted into vertica Target Table

I am loading rows from a SQL server table to a Vertica table using Informatica. I was able to insert into another table but this one table I am trying to insert the rows are read from the source table but none are beining inserted into the target table. In session log I did not find a INSERT query being generated. Here is the entry from session log: Usually there is an insert query issued when inserting rows into the target. I have tried running INSERT statement using a SQL editor and was able to insert rows.


Severity: INFO
Timestamp: 6/12/2015 11:14:10 AM
Node: node01_ustryetl02
Thread: WRITER_1_*_1
Process ID: 4924
Message Code: VERTICA_3333
Message: [INFO] Executed query : : [null]


  • Hi Sudhamsh,


    Thanks for your question. I am looking into an answer and will get back to you as soon as possible.



  • Hi Sudhamsh,


    Please provide the complete Informatica session logs and if possible the mappings and workflow xml files.

    Also provide the information about the environment - Informatica version,Vertica version and the connector - if it is odbc or is this vertica plugin?











Leave a Comment

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