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]
0
Comments
Hi Sudhamsh,
Thanks for your question. I am looking into an answer and will get back to you as soon as possible.
-Vicki
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