I used Datastage to insert and select data from vertica using ODBC driver and connector. But when i started performing update / delete for 100 records its taking 2 minutes. The same is taking seconds in VSQL. Please help.
Data Stage is the ETL tool not ELT.
Sometime it is better to use ELT instead of ETL.
If you age going to use batch loading try to use Vertica COPY DIRECT not Data Stage insert
We have published Datastage document in the community.https://my.vertica.com/kb/DataStageCG_HTML/Content/Partner/DataStageCG_HTML.htm
Take away ... Vertica understands ODBC, JDBC, OLEDB, ADO.NET, etc
We offer the best platform.
Here's an article on our Knowledge Base about connecting to DataStage: