Problem using tVerticaOutputBulkExec

[Isabel_R]

Hello everybody,

I have to realize a massive data update in a vertica table. I'm using the component tVerticaOutputBulkExec (Talend version 5.5.1). It seems to work ok, no errors, the file is genererated with the correct data but after the processus is finished I can see that the table in database has been not updated. If I changed the component and use un tVerticaOutput instead it works ok but I need to use the tVerticaOutputBulkExec due to the big volumetry. I have used this component other times with no problem so now I really have no idea what can be the problem. There are any specifics requirements that the table to be update has to fullfill? Do you have any other ideas?

All advices are welcome!

Thanks in advance.

[Anonymous]

Hi,

    Two quick queries.

a) Have you selected the key tick box for the columns used for bulk update (please check the schema details)?

b) Have you selected the Acton on data as Bulk update?

Warm Regards,

Nikhil Thampi