Informatica no rows inserted into vertica Target Table

msudhamsh

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]

[Deleted User]

Hi Sudhamsh,

 

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

 

-Vicki

PraJain

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?

 

Thanks

Praveen