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.
Timestamp: 6/12/2015 11:14:10 AM
Process ID: 4924
Message Code: VERTICA_3333
Message: [INFO] Executed query : : [null]